02-26-2018 12:37 PM - edited 02-27-2018 09:51 AM
We're working on SAS FM Studio. With Cycles and Models. We don't know if the system runs on cubes
We have two Cycles: Rampa and Revenue
We copied data from one cycle to another.
In Revenue there are the same dimensions that are in Rampa, and some more.
In Revenue, we have a model where the dimensions are based on different hierarchies than in Rampa. We need to do a member formula that has to multiply price * quantity.
Price and Quantity are both members of the same dimension (Account), but are on different hierarchies. Our formula only works if we put both members in the same hierarchy. We need to make it work when both members are in different hierarchies because they belong to different cycles.
The formula KRV2 multiplies RA18 * KRV01. Initialy, both members (RA18 and KRV01) were in different hierarchies. And the formula didn’t work. Please see KRV02.
But when we put both members in the same hierarchy, it worked.
Question: Is there any way to make formulas that combine members of different hierarchies/models/cycles?
Is it possible to make formula members that refer to excel cells or excel calculated members?
Does the value of member formula data persist in the database?
Thanks in Advance!!
02-27-2018 02:13 AM
02-27-2018 09:24 AM