OLAP Cubes and storage of data

[metalray]

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

[LinusH]

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

[metalray]

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 Now, since you
say it work. I might need to look over it again.

[metalray]

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

How did you do that?

[lacrefa]

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

[metalray · Accepted solution]

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

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

[LinusH]

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