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 |
|
Prometeo
Starting Member
3 Posts |
 Posted - 2003-09-19 : 10:39:43
|
| This is the scenario. Need to develop a calculated member which> calculates composite yield.> > eg:> Dimension:> Process:> ---Assy> ---Test> ---Final> Calculated member: FPY> Dimension : Fiscal Date > Dimension : Product: N > > Then:> composite yield = (FPY for each process/100)> > Cube Table sample:> > Process FPY Date Product> Assy 90 Sep N > Test 80 Sep N> Final 100 Sep N > > Composite Yield for Sep = (90/100*80/100*100/100) > > Hope the above example is clear. How do I create a calculated member to> achieve this calculation.> Any examples will be highly appreciated.> > Thanks in advance. |
|
|
|
|
|
Calculated Member Help