Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-03 : 08:59:29
|
| mike writes "I have a parent-child dimension in in an OLAP database. With some members I only want to aggregate a certain percentage of the measures in the fact table. It would seem I need a custom member formula I know I need to create a column in the underlying dimension table to hold an MDX expression, but what is the syntax of the expression? I have tried (for example): H_Cons.&[27] * 0.33 and Measures.[value] *0.33 etc etc. All I get is #ERR when i browse the cube data post processing. I have found an example in the Foodmart database but it doesn't bear the slightest resemblence to what I am trying to do. Anyone got any ideas??? Maybe an example??? Cheers Mike" |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-07-04 : 00:58:01
|
| Please specify the Error in detail---------------------------Sandesh - The Messanger |
 |
|
|
MikeArnold
Starting Member
11 Posts |
Posted - 2002-07-08 : 20:23:18
|
quote:
Please specify the Error in detail---------------------------Sandesh - The Messanger
|
|
|
|
MikeArnold
Starting Member
11 Posts |
Posted - 2002-07-08 : 20:24:30
|
| Hi Sandesh --- All you get is "#ERR" in all cells "above" and in the same path as the member with the formula. |
|
|
|
|
|
|
OLAP - custom member formula