Forum Discussion

JacobH's avatar
JacobH
New Contributor II
2 years ago

Best way to make a cubeview that compares a static scenario to a selection of scenarios

Hi all - I am creating a cubeview that seems basic at first glance, but have ran into some walls as I am still new to using cube views on my own.   What I have is an entity, net sales, profit, pro...
Cube View
Parameters
dimitriosc's avatar
dimitriosc
New Contributor III
2 years ago

Hi JacobH, 

In addition to Omkareshwar's recommendation you could also leverage the UD8 Dimension to create dynamic retrieves of data based on your requirements for Reporting purposes. 

For example, having a UD8 member called "PY" with the below dynamic formula would retrieve your PY data. 

----------------

If (Not ViewMember.IsAnnotationTypeViewId(api.Pov.View.MemberId)) Then
Return api.Data.GetDataCell("U8#None:T#" & api.Time.GetNameFromId(api.Time.GetPriorYearPeriodId()).ToString )
End If

------------------

Similarly, a UD8 member called "VariancePY" with the below piece of code would generate your variance between current and last year periods. 

-------------------

If (Not ViewMember.IsAnnotationTypeViewId(api.Pov.View.MemberId)) Then
Return api.Data.GetDataCell("U8#None - T#POVPrior12:U8#None")
End If
 
Return Nothing
---------------
 
Experimenting with the use of UD8 members for reporting and relevant scripts can be fairly powerful and help you create dynamic reporting outputs.
 
I hope this helps!
 
Dimitrios