BookmarkSubscribeRSS Feed
drot_QG
Calcite | Level 5

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.

Screen1.png

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.

Screen2.png

But when we put both members in the same hierarchy, it worked.

 

Screen3.png

 

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!!

 

Drot

2 REPLIES 2
LinusH
Tourmaline | Level 20
Bayou have quite specific/detailed problem and at least for me hard to follow. A data model and/or sample data may help to describe the situation.
And then I get a bit confused about the environment. Are you using OLAP cubes which you browse from Excel (with SAS Add-in 4 MS Office)?
Data never sleeps
drot_QG
Calcite | Level 5
Linus, thanks for your response. I updated the initial post with screenshots. We're working on SAS FM Studio, with no direct access to cubes.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 697 views
  • 0 likes
  • 2 in conversation