Hi all-
Not sure if this is the right place to post this as I don't see a forum for OLAP studio but my question is pretty simple, if this is the incorrect place can a moderator please move to the correct location?
When you have a cube open and you drag your dimensions over to the rows, how do you set it up so that a new dimension does not automatically become part of the drill down for the previously selected dimension? You can do this via Cognos, but not sure how to do this in SAS OLAP.
For example I have the dimension called say "measure 1" and it has five buckets as follows. My column is an arbitrary selection called "count"
Count
grp1
grp2
grp3
grp4
grp5
Then say I want to add a dimension called "city" with 2 cities to the current layout, but by default, SAS OLAP adds it as a drill down as such:
Count
grp1 city1
city2
grp2 city1
city2
grp3 .......
and so forth.
What I want to do is add it as a new set of rows as such:
Count
grp1
grp2
grp3
grp4
grp5
city1
city2
How do you go about doing this in Cube studio?
Doing some cleanup and noticed this wasn't answered ... replying to your message will "bump" it into the streams again - we'll see if it gets some traction. Hopefully, you have already found a solution, though
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.