Hi Guys,
We will see about the types of cross calculations in SAP Analytics Cloud in this blog post.
There are three types of calculations in Cross calculations:
Calculated Measures:
Calculated measures is a measure where an user can ...
Hi Guys,
In this blog post, we are about to see how to calculated the Current year (CY) Vs Previous Year (PY) variance using cross calculation in SAC.
Let's say we have created the model with the below dataset.
Steps to find the Variance:
...
In this blog post we will see how to update the model with additional or new field/dimentions in a model in SAP Analytics Cloud.
Steps:
open the model which you need to update.
Let's say, In the current model we have imported data from an un...
In this blog, we will see about how to create the custom calculated measures in SAP Analytics Cloud.
In SAC, we can create custom calculated measures in two places. In
Models
Stories
In Models:
If we create calculated measure in a model, then...
Hi Pablo Jose,
Please make sure that you are adding the dimension in 'Model' tab because adding dimension in 'Data Management' tab will not be enabled.
Thanks.
Hi Tomas,1.In your story, when you click on the table on the right side pane Please add calculation under Table structure/Columns/Accounts.2. In the formula box, please use the "%GrandTotal" function.In your case the folrmula should be %GrandTotal(Ac...
