Desktop productivity for business analysts and programmers

Set default view for OLAP cube?

Reply
N/A
Posts: 1

Set default view for OLAP cube?

Sorry if this is in the wrong spot but I didn't see a forum for SAS Olap Cube Studio. I created a cube and processed it successfully. I'm able to open the cube in Enterprise Guide but the default view when opening is set to the last dimension I added.. which is quite large! The result is that the cube takes a long time to load when opened. How do I change the default view for the cube when it's opened by the user??

Esteemed Advisor
Posts: 5,198

Set default view for OLAP cube?

I was just looking for an answer to this myself - and I haven't seen anything that suggests that this is possible. A typical SASWare ballot item?

My work-around is to us a WRS report, where a default layout is defined.

I have a NUNIQUE measure based on a customer dimension, which itself shouldn't be visible for the user - this is also handles by the WRS. But if your users need to access the cube from EG, I guess this will not work for you...

/Linus

Data never sleeps
Contributor
Posts: 53

Set default view for OLAP cube?

I opened a ticket with SAS support and this info may be useful.. although not really a solution:

The SAS Enterprise Guide OLAP Analyzer uses the followinglogic to determine which dimensions will be placed on rows or columns:

Do until a dimension is placed on Columns

   If a TYPE = TIMEdimension exists, place it on columns

   Else if adimension with the name "customer", "geog","account", "product", "market","employee" or "store" exists, place it on columns

   Else select thefirst dimension defined to metadata that does not have TYPE = GEO.

Do until a dimension is placed on Rows

   If a TYPE = GEOdimension exists, place it on columns

   Else if adimension with the name "customer", "geog","account", "product", "market","employee" or "store" exists and is not already used incolumns, place it on rows

   Else select thefirst dimension defined to metadata that does not have TYPE = TIME and is notalready used on columns.

Calculated members will not be selected by default forthe display in any client. The default measure will always be selected based onthe DEFAULT option in your MEASURE statements.

Another option available - you can create a view and savethat view within the SAS Enterprise Guide OLAP Analyzer or as a spreadsheet inMicrosoft Excel. If that project/workbook is opened again, that view will bepreserved.

Esteemed Advisor
Posts: 5,198

Set default view for OLAP cube?

Wow, amazing... Real hard-coded logic, right? And what about NLS support... Smiley Wink

Data never sleeps
New Contributor
Posts: 2

Re: Set default view for OLAP cube?

I'm using PROC OLAP in EG 5.1.

 

SAS uses the first dimension in alpha order rather than defined order to add to rows. Might be different in differing environments however this is what I have observed.

 

Andy

Contributor
Posts: 36

Re: Set default view for OLAP cube?

There is an option in Enterprise Guide: Tools --> Options go to OLAP Data.

Here you can set de 'Default Actions for Opening OLAP Cubes'

 

If you choose 'Always open with options' then the cube doesn't automaticly create a view when opening, but askes you wich dimensions and measures you want to use.

New Contributor
Posts: 2

Re: Set default view for OLAP cube?

 Won't work for me, as my cubes are accessed through a web portal Smiley Happy

Contributor
Posts: 36

Re: Set default view for OLAP cube?

:-)

Our users do not directly acces the cube via the portal. We place an information map between the portal and cube. In the information map you can set a 'default query'.

 

Ask a Question
Discussion stats
  • 7 replies
  • 612 views
  • 0 likes
  • 5 in conversation