Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to create Calc Member for one Measure across Dims (SQL2K)

Status
Not open for further replies.
IMAGINAX

IMAGINAX

MIS
Apr 16, 2003
10
GB
Struggling with this... :)

We sell 10 products and I have built a cube of the Relational Database that holds our sales (I can't mess with this).

My cube has just the one measure which is the NumberSold. A hierarchy dictates which product it was. The problem I have is that I want to write a calculated member that gives me 1 prod - another one + (one divided by another).

All the other cubes I have used were fine because there was a measure for each thing I wanted to mess with but here it's the same measure... just a different part of the hierarchy.

Help!

Mike

P.S. Using Analysis Manager in MS SQL 2k
 
Status
Not open for further replies.

Similar threads

Vary88
  • Locked
  • Question
Both One-Many and Many-One relations in fact table
Replies
0
Views
660
Vary88
Vary88
MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
1K
k5tm
k5tm
maxzikpi
  • Locked
  • Question
How to Create a cube with a survey result. Pls help!
Replies
4
Views
798
maxzikpi
maxzikpi
vktrez
  • Locked
  • Question
Best OLAP Tools 1
Replies
1
Views
730
fominlena
fominlena
acoronel
  • Locked
  • Question
Error message to use active directory authetication to access SQL database.
Replies
0
Views
641
acoronel
acoronel

Part and Inventory Search

Sponsor

Back
Top