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