topic Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS in SAS Programming

SAS OLAP Cube hierarchy

sameer112217 — Mon, 13 Jun 2016 13:00:36 GMT

Hello Everyone,

Suppose I have one dimension in OLAP cube called Customer and with hierarchy with same name called customer and in that I have four levels

Customer Age

Customer_gender

Country

Customer_id

I want to add a level with a name "customer_name" and want it to associate with customer_id.. how can I do that?

Is it by adding member level property to customer_id or just add customer level behind placing it after customer_id in the hierarchy or by level attribute. My analysis is that you have to add member level property. Please suggest.

For more information, please refer to the attached picture

Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

LinusH — Sun, 12 Jun 2016 20:12:57 GMT

I hope that picture isn't from a certification exam.
Also, are you just reading about this? Having access to SAS makes it much easier to learn.
The title of this post is very confusing, sounds like quite different topic...

For your question I think both options are available. So it depends on how you wish to use the name. But if you are clear about adding it as a level, then you add it to the hierarchy.

Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

sameer112217 — Sun, 12 Jun 2016 20:52:14 GMT

IT is a certification questions and I failed in the exam because SAS BI notes are horrible online... worst.. I asked for a help and I intend to reappear in the exam with clarrifying doubts on questions which I am not sure.

Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

LinusH — Mon, 13 Jun 2016 06:57:32 GMT

You should not take pictures on the exam questions, and definitely not spread them - can cause you to be banned from certification in the future.

Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

sameer112217 — Mon, 13 Jun 2016 07:53:29 GMT

Pictures from exam? have you heard about dumps? it is that my dear. When SAS has worst notes for SAS BI, I have to clarity. There is one book for Andrea Tricia and it is the worst book which to understand SAS BI content developer...

Re: Connect to SQL Server Analysis Services OLAP Cube Through Base SAS

ShelleySessoms — Mon, 13 Jun 2016 13:03:11 GMT

Hello, I am a community manager on the SAS Support Communities. I understand your frustration around the exam, however, it is not appropriate to share images from the exam. Therefore, I have edited your post to remove the image. I have also contacted the SAS certiication team in hopes they can offer some you some guidance.