I have deleted the existing Customer_Id column from the metadata and imported the column as per the note.....Voila the cube is built. Thanks angela! ... View more

A great resource for developing a custom sort order in Web Report Studio is the sample: http://support.sas.com/kb/33/017.html ~ Angela ... View more

Thanks Neha, That was helpful. ... View more

You can check out http://support.sas.com/kb/19/765.html for more information about how cardinality affects result set size (and in turn memory consumption). ... View more

Wow! Thanks so much for your quick response!! ... View more

I have used the Delete option in the OLAP code to do that. However the issue is resolved after manually deleting the cube files and re-building the cube. ... View more

Just ran across this Knowledge Base entry: http://support.sas.com/kb/33/017.html Could be helpful for custom sorting. ~ Angela http://sas-bi.blogspot.com ... View more

Can you explain the above code a bit. Where are you now using the custom format in the code now. iif([Measures].[Value] or [Measures].[Value] = 0,     PUT([Measures].[Value],"myfmt."),  "NO VALUE") ... View more

The best option for non-additive measures is to store the data as a member property. Member properties are not aggregated across any dimension and can be retrieved as calculated members for use in calculations. MDX supplies some functions such as ClosingPeriod that can be used for semi-additive measures, or those that are aggregated across some but not all of the dimensions in the cube. Examples of the PROPERTY statement in PROC OLAP can be found in the SAS OnlineDoc under SAS OLAP Server -> SAS OLAP Server: User's Guide -> The OLAP Procedure -> PROPERTY Statement. Also in the SAS OnlineDoc is the SAS OLAP Server: MDX Guide which includes syntax and examples for the MDX functions available in SAS 9 OLAP. I also find that http://msdn.microsoft.com is a very useful site for syntax questions and examples on the MDX language. ... View more

Hi Barry, Thanks for the reply. The Information map created on the cube is reflecting the same name in the OLAP Viewer. This explains that even if we access the cube directly from the Web Olap viewer sas generates an automatic Information map. Regards, Raj ... View more

Hi TSBruce, Thanks for the reply. This document covers how to define the row-level permissions using the SAS.IdentityGroups property based on an External table. In my case I have created the Information exactly as defined in the document, In addition I have created Prompt in my information map. So When an User logs in, based on the group that the user belong the values in the prompt are determined from the external table. My Question is that can I apply default values for my prompt ? i.e. each group should have an unique default value. ... View more

Are the other users in the group portal administrators? The page is not added automatically to the portal view if they are. ... View more

It worked Like a charm..Thank You Anjela!! Message was edited by: RSB ... View more

Or use an URL display portlet. You can then format it to look any which way you want. On the other hand of course you have to write the HTML yourself and maintain the links. ... View more

Great!! It works with the Web Reprot studio also.!! Thanks a mill. ... View more