Traditional web-based reporting with SAS BI tools

Changing source dataset for a Cube

Reply
Super Contributor
Posts: 275

Changing source dataset for a Cube

Hi,
I have built a cube Test using dataset A. Now in OLAP Cube Studio, I am trying to change the data source from dataset A to dataset B ( which is also registered in the metadata). I no longer want (or need to do anything) with dataset A.
Is this possible?

Thanks,
Raj.
SAS Employee
Posts: 238

Re: Changing source dataset for a Cube

You can do this by editing the cube structure - however you will then be required to rebuild all the dimensions/hierarchies & define measures again. No problem if it's just a couple of clicks, however this is usually not the case. Here is my recommendation:

In OLAP Cube Studio export the full code & in base SAS modify the data source line to point to the new table.

from - Data=dataset.tablea
to - Data=dataset.tableb

To rerun this NEW code manually in base SAS, you will first need to delete the current cube in OLAP Cube Studio (or you can add a couple lines above the exported code to delete the original cube - here is my blog post on that tip: http://sas-bi.blogspot.com/2005/08/refreshing-olap-cubes.html).

This will save you the trouble of recreating all the dim/hier & measures.

~ Angela Hall
http://sas-bi.blogspot.com
Super Contributor
Posts: 275

Re: Changing source dataset for a Cube

Hi Angela,
Thanks for the info. But, I decided to create a new cube altogether (with new heirarchies/dims/measures).
But now I have a different issue - The log in OLAP Cube Studio shows "...Cube created succesfully...". I see the cube and its properties in OLAP Cube Studio but I dont see it in EG.
Any suggestions?

Thanks,
Raj.
SAS Employee
Posts: 238

Re: Changing source dataset for a Cube

Hi Raj,
This is a common issue. The default security for OLAP in SAS Management Console doesnt allow users to have read metadata access. You can change this on the cube itself (but that would need to be done everytime the cube is completely rebuilt) or you can change it on the OLAP schema (but that allows ALL cubes in the area to be readable).

Here is a blog post I did awhile back that relates to this:
http://sas-bi.blogspot.com/2008/12/olap-viewing-issues-in-enterprise-guide.html

~ Angela Hall
http://sas-bi.blogspot.com
Ask a Question
Discussion stats
  • 3 replies
  • 210 views
  • 0 likes
  • 2 in conversation