topic Re: OLAP Cubes and storage of data in SAS Procedures

OLAP Cubes and storage of data

metalray — Thu, 27 Sep 2012 08:41:41 GMT

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

Re: OLAP Cubes and storage of data

LinusH — Thu, 27 Sep 2012 10:34:03 GMT

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

Re: OLAP Cubes and storage of data

metalray — Thu, 27 Sep 2012 11:46:04 GMT

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.

Re: OLAP Cubes and storage of data

metalray — Thu, 27 Sep 2012 13:04:14 GMT

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

How did you do that?

Re: OLAP Cubes and storage of data

lacrefa — Thu, 27 Sep 2012 13:55:37 GMT

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

Re: OLAP Cubes and storage of data

metalray — Thu, 27 Sep 2012 14:13:32 GMT

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

Re: OLAP Cubes and storage of data

LinusH — Thu, 27 Sep 2012 15:16:58 GMT

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