dbTalk Databases Forums  

Calculated Member - can it solve my problem

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Calculated Member - can it solve my problem in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lamm
 
Posts: n/a

Default Calculated Member - can it solve my problem - 05-24-2006 , 10:19 AM






I have a cube where the fact data lists project parameters, e.g. say 2 rows
per project where each row maps a project parameter which has the score 0 or
1

PROJECT PARAMETERNAME SCORE
Project1 param1 1
Project1 param2 1
Project2 param1 1
Project2 param2 0

Per project I want to have a measure, ProjectScore, that is set to 1 or 0
based on a MIN aggregation of all SCORE values for each project (ProjectScore
is 1 for Project1 and 0 for Project2 in the example above).

What I then want to to aggregate an average(%) of the projects that has
ProjectScore=1 (for the example the total aggregation is 50%).

I am currently looking into setting up two calculated measures to simulate
this, but I'm not there yet... (I could set up two separate cubes, and then a
virtual cube on top - but what I want to accomplish is to be able to filter
out specific parameters and see how that affects the percentage aggregations,
a feature I can not get by using two cubes)

I would appreciate advice on how to set up these aggregations.
Lamm

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.