Ultimately I want to have those dynamic cascading prompts in a web based user interface. will that be possible with the "custom" approach? ... View more

Thanks Angela. Thats what I was looking for. Your suggestions are a real contribution to this board. But how do I dynamically generate a MDX query based on non OLAP selections from relational based prompts?You mentioned a stored process. I will try that and let you know. My first idea to that solution is to use SAS Access and read the data from a SAS library with views (Access Engine) so I dont have to do a refresh. ... View more

Hi Angela, Thanks for your suggestion. I solved the case now. When I said "Well, if it appears differently in the column subcategory than it is a different parent of MEASURENAME, correct?" I was wrong. the member caption has to be unique regardless of upper and lower case characters. I just did not understand the error : ) ... View more

Hi Angela, Thanks for your reply. I still dont understand why a SAS OLAP cube cant be built. Executing the following SQL on my Oracle staging database: select distinct MEASUREKEY, SUPERCATEGORY, CATEGORY, SUBCATEGORY, MEASURENAME, SOURCE from mytable results in 743 rows. the total rows are 743. that means each row is a unique top to bottom hierarchy. I dont understand why I get an error telling me their are duplicates. You said "Essentially the error msg means that the 'testmember' value appears differently in the SUBCATEGORY level of your hierarchy" Well, if it appears differently in the column subcategory than it is a different parent of MEASURENAME, correct? the full error reads: ----------------------------- ERROR: A duplicate member caption was found in "SUBCATEGORY" level for value "growthxxxxxxxxxxxxxxxxxx xxxx ". It may be that the same caption exists with different variants of upper and lower case characters, o r with a different number of leading blanks. The MDX language is case tolerant so having one or more captions that differ only i n the case or number of leading blanks makes the captions ambiguous. ERROR: Hierarchy "DIM_KPI" could not be initialized. ERROR: Cube "xxxxx" cannot be created. --------------------------------------- There are not that many spaces in any of the rows under columns SUBCATGORY. A statement like this select measurekey,subcategory from T_measures where subcategory LIKE '% %' results in not a single row returend. So I can not make out to what member name the error refers. ... View more

Is there any way to provide cascading OLAP prompts? via stored processes or in the information map? ... View more

It neither works with my enterprise guide. I have not changed the system locale but the enterprise guide language and the cube dimension members are still displayed in the default language. finally, changing the system locale (windows xp) made the difference and it all worked. interestinly I wonder then if the web application "sas web report studio" accesses the system locale to determine the language. quite unusual for a web application. ... View more

Thanks TSBruce ... View more

Levels can be shared within a dimension. So if certain members or whole levels would be needed again we can practice re-use by making it "just" another hierarchy. ... View more

Hello, I have had a look at opening a cube in EG and it seems I have to define a slice and temporary table as well. associating the stored process to an information map also requires a table. now, this is getting a bit too component heavy. I was hoping to build a query or mdx expression (to just get the member property e.g. alternative naming of members in a different language) that queries the cube without going all the way through sas data sets, tables,views, slices, etc. is that possible? ... View more

Thanks Angela. I will try that. ... View more

Hi Angela, thanks for that. I was afraid I had to select an individual member and unfortunately this does not helpe me 🙂 Depending on the information map I want to display the AliasName instead of the real name. Different hierarchies does not work either since the levels would not change just the member name. Thanks again ... View more