-
Set the value of member's descendants
Hi,
I'm using as2008
this is my problem:
I want to create a caluclated member whose value is 1000 for a given member value of a hierarchy. I don't know the level level of the member in the hierarchy
i.e. member 5952002
My hierarchy
[12345]
| |--[789]
| | |--[5952002]
| | |--[654]
| |
| |--[901]
| |--[431]
| |--[914]
| |--[5952002]
| |--[776]
|
|
[98765]
| |--[589]
| |--[133]
| |--[5952002]
| |--[888]
[5952002]
I have to set the values of the caluclated member of all the [5952002] to 1000.
I have tired this:
Create Member CurrentCube.[Measures].[Trascinamento_vb] As
[Measures].[importo],
FORMAT_STRING = "Currency", VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'PUMA' ;
Scope (Filter(descendants([Dizionario].[Aggregati].currentmember,,self_and_after),Instr([Dizionario].[Aggregati].CurrentMember.name, "5952002") > 0),[Measures].[Trascinamento_vb]);
this=1000;
end scope;
But the system give me this error:
"set with arbitrary shape are not allowed in the current context "
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|