As of version 5.0.6 it It is possible to add textual columns to your reports. These textual comments can be useful to tell the user to enter line item comments or not. In the example above the user is kindly requested to explain why the relative variance between actual and budget is above 10%.
...
Create a cube calc to display the text. For the example above the following cube calc has been used:
Code Block language sql CASE WHEN ISEMPTY([CAT].[CAT].[Budget]) OR [CAT].[CAT].[Budget] = 0 THEN NULL ELSE CASE WHEN ABS(([CAT].[CAT].[Actual]-[CAT].[CAT].[Budget])/[CAT].[CAT].[Budget]*100) > 10 THEN "Please explain why > 10%" END END
- Add this cube calc to an empty column
...
Info |
---|
|
...