Can I Save My Report As A View?

Anonymous shared this question 2 years ago
Answered

Yellowfin version 7.2 introduced new functionality dubbed 'report from report' that allows report writers to save their reports as a view in order to report from that subset of data later. Report from report provides an alternative to using sub queries or virtual tables to solve complex reporting requirements.


For example, the below report contains an aggregation (average) of my number column:

73c3d56f150ace23f068521edccb321b


But lets say I would like to apply another aggregation to my column...this is where 'report from report' comes in handy. After enabling the role permission 'Report as a Datasource':

a56d2f14088cac691c23638e18acee9f

I can then save my report as a view:

c6cf346eca3362cc153c7a01ad76e757

When I create a new report, I have the option of selecting the previous report as a view:

4a909260f5abdea228ce93ab8f4bf36b

From here I am able to apply a second aggregation to my column:

3c457f64275818fc56e6cc57db1d1e90

Now this is a pretty rudimentary example, but it does show the power of report from report especially when you consider data sets that contain calculated fields, advanced function, and multiple aggregations.


Kind Regards,

Dustin