SAS ERROR MESSAGE ON WINDOWS XP

Asked By marc. 0 points N/A Posted on - 07/18/2011

Hello there,

I have a SAS 9.2 OLAP installed on my Windows XP computer. I have an OLAP cube containing sales data of all sales agent in our company including me. When I was trying to access my user id. I get stuck into this error message.

 

The application encountered an error verifying the following

statement:

CREATE SESSION SET

[TransactionsCube].TEMPORARYNAMEDSET AS

{[Dim SalesPerson].[All Sales People].[SUB::SAS.Userid]}

 

I had no problem using this user id before but is it possible that I can see this error message because my user id is no longer valid in our company database? Has anyone had the same trouble using SAS 9.2 OLAP?

How will I know if the syntax error is due to the placeholder or the rest of the MDX? Any help would be appreciated!

Thanks.

• Status: Open
• Question Views: 1389
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: SAS

Answered By Balram 0 points N/A #82023

SAS ERROR MESSAGE ON WINDOWS XP

To create a named set, use the New Named Set command on the Calculations tab of Cube Designer.

This command can be invoked on the Cube menu on the Calculations tab toolbar. This command displays a form to specify the following options for the named set:

Name:
Select the name of the named set. This name appears to end users when they browse the cube.

Expression:
Specify the expression that produces the named set. This expression can be written in MDX. The expression can contain any of the following:

• Data expressions that represent cube components such as dimensions, levels, measures, and so on.
• Arithmetic operators.
• Numbers.
• Functions.

You can copy or drag cube components from the Metadata tab of the Calculation Tools pane to the Expression box in the Named Set Form Editor pane.

You can copy or drag functions from the Functions tab in the Calculation Tools pane to the Expression box in the Named Set Form Editor pane.

About Balram

Questions
0

Answers
47

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 07/26/2011
• Question Category: SAS