topic Set default view for OLAP cube? in SAS Enterprise Guide

Set default view for OLAP cube?

Frank2808 — Fri, 27 Jan 2012 05:12:24 GMT

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

Set default view for OLAP cube?

LinusH — Fri, 27 Jan 2012 11:54:38 GMT

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

Set default view for OLAP cube?

FrankE — Fri, 27 Jan 2012 16:49:00 GMT

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.

Set default view for OLAP cube?

LinusH — Tue, 31 Jan 2012 19:44:21 GMT

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

Re: Set default view for OLAP cube?

AndiChrist — Fri, 19 Feb 2016 01:00:24 GMT

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

Re: Set default view for OLAP cube?

Matthijs — Tue, 23 Feb 2016 15:49:41 GMT

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.

Re: Set default view for OLAP cube?

AndiChrist — Wed, 24 Feb 2016 03:18:43 GMT

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

Re: Set default view for OLAP cube?

Matthijs — Wed, 24 Feb 2016 07:15:42 GMT

🙂

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'.