I will not be downloading this at this stage. I've been reading the available documentation but am confused about the functionality that it offers.
The following:
Universal Report static layout
says:
--------------------------
The behavior of this report is similar to IBM Planning Analytics for Microsoft Excel Quick Reports but offers these advantages:
- You can modify the content of a Universal Report static layout can be done without the use of expressions. For instance, you can type over header names to refer to different elements or add labels for custom user rows or columns.
- You can create spacer rows or columns in IBM Planning Analytics for Microsoft Excel by right-clicking a row or column, and selecting insert.
- You can create Universal Report static layout content using hierarchies.
- You can insert user rows and columns and Excel formulas into the body of the report alongside your TM1 data.
--------------------------
Aren't points 2 to 4 already available in Quick (I have previously inadvertantly written Universal) reports?
But I guess I'm not really that interested in Quick (As above ) reports as I have found them too limited. I'm more interested in whether this can offer something closer to Dynamic Reports.
Looking at: Universal Report static layout named ranges
I see that " The q named range maps to the MDX query of the Universal Report static layout. You can modify the MDX of a Universal Report static layout to determine which members appear in the report."
Does this mean that we can have a custom MDX statement:
1) Generated in a similar manner to what can be done with dynamic reports using Excel formula? (Thought this would not be just dimension MDX but rather full MDX)
2) Then applied to the Static Report layout at that time and hence the content will be dynamic with the rows/columns potentially growing or shrinking?
I understand that it is not dynamic in terms of being able to click and shrink/expand.
I see from Supported features and limitations in Universal Reports static layout
The following are features that are not supported by Universal Report static layout:
- Toggle on rows and columns.
- Indents per level, ActiveDisplay, ExpandAbove, and Display toggle properties. They will have no effect on the report.
- Conditional formatting formulas at report generation time. These need to be manually added if desired.
So putting that aside, if I created URSL report could I create a similar outcome to a dynamic report by having a variable MDX statement which would generate dynamic row members with inserted columns with TM1VAL formulae to reference multiple other cubes within that context, then save and use it ongoing as something that is pretty close to a dynamic report (Without those functions noted above)