Help using Base SAS procedures

OLAP Cubes and storage of data

Accepted Solution Solved
Reply
Regular Contributor
Posts: 207
Accepted Solution

OLAP Cubes and storage of data

Hello,

I have learned that I can create a SAS OLAP Cube
from a 1. detail table, 2. star schema 3. summarized table
now I wonder if I create the cube, is all the data then stored
as/in the cube and I can delete my sources?

Secondly, is my assumption right, that the source tables always have to be registered

in the meta data or can I build cubes (PROC OLAP) with tables that are not registered?

Thanks


Accepted Solutions
Solution
‎09-27-2012 10:13 AM
Regular Contributor
Posts: 207

Re: OLAP Cubes and storage of data

Hello lacrefa,

Thanks for your reply. You are saying I have to register the tables, Linus is saying

I dont. Lets see if a third person has an opinion Smiley Happy

I dont use OLAP CUBE STUDIO but build my cubes using PROC OLAP.

And yes, I can manage my metadata I am the administrator.

Thanks

View solution in original post


All Replies
Super User
Posts: 5,427

Re: OLAP Cubes and storage of data

As a general rule - as long you don't specify drill through for the cube, the source tables are not needed for reporting on the cube.

No, they don't have to, as long as Proc OLAP can read the source tables. But as a best practice, I favor havingall tables registered in metadata.

Both theses scenarios can you easily test by yourself...

Data never sleeps
Regular Contributor
Posts: 207

Re: OLAP Cubes and storage of data

Hello Linus,

Thanks for you input to clarify the storage. I looked through a lot of SAS documentation but could not find explained what you just said.

I did test the scenario and it did not work Smiley Wink Now, since you
say it work. I might need to look over it again.

Regular Contributor
Posts: 207

Re: OLAP Cubes and storage of data

Linus, I tested it again and the PROC OLAP error is "Metadata registration of table X was not found."

How did you do that?

Contributor
Posts: 22

Re: OLAP Cubes and storage of data

Dear

To build a OLAP cube, you need register all tables used by the proc OLAP. To understand the mind, you need use the OLAP Cube studio.

If you can not manage your metadata, you must request to an Administrator of Metadata.

Regards

Solution
‎09-27-2012 10:13 AM
Regular Contributor
Posts: 207

Re: OLAP Cubes and storage of data

Hello lacrefa,

Thanks for your reply. You are saying I have to register the tables, Linus is saying

I dont. Lets see if a third person has an opinion Smiley Happy

I dont use OLAP CUBE STUDIO but build my cubes using PROC OLAP.

And yes, I can manage my metadata I am the administrator.

Thanks

Super User
Posts: 5,427

Re: OLAP Cubes and storage of data

My bad, I got carried away by that the data= option is specied in the old fashion style libname.table, not a metadata reference.

Apparently, I always use to have all my tables registered...

Data never sleeps
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 320 views
  • 6 likes
  • 3 in conversation