Help with report building
Source: Migrated from Champions
Hey Everyone,
I am trying to create a report/cubeview for our regions. But how do I get the dynamic calculation inserted into my CV? (Highlighted Yellow) Do I ne...
Forum Discussion
Hi Mustafa,
There isn’t much information here so answers will be a bit generic. There is likely a metadata way to get to your Profit Margin. Questions for that include things like what type of chart of accounts do you have (functional vs. natural) or is there a UD involved (department or line of business, etc.)? Alternatively both rows could have a GetDataCell expressions (see samples in the Member Filter Builder dialog). These work with any POV. Copied straight out of the samples: GetDataCell(S#Scenario1-S#Scenario2):Name(Difference) and GetDataCell(VariancePercent(S#Scenario1,S#Scenario2)):Name(Var %)
You can also use the Column/Row Expressions. Those are definitely more difficult if member expansions are in play.
Another way to do this would be to create a dynamic calculation in a member formula. Most people put those in UD8, but they can live in any dimension. It’s very similar to the GetDataCell method.
Thanks,
Andy