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