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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculated Measure using non-dimension info

Status
Not open for further replies.
Bygbobbo

Bygbobbo

Programmer
Apr 23, 2002
145
US
I am trying to sum an amount field according to a field that is not in a dimension but exists in my fact table. Basically, I am trying sum up the amount only when this field has a particular value..

thanks in advance..
 
Status
Not open for further replies.

Similar threads

brk1221
  • Locked
  • Question
ODBC connection from Windows to IBM Informix
Replies
3
Views
615
genomon
genomon
tarikqazza
  • Locked
  • Question
problem with calculated member and currentmember
Replies
0
Views
92
tarikqazza
tarikqazza
josmi
  • Locked
  • Question
How to design a fact table to keep track of active dimensions?
Replies
7
Views
174
johnherman
johnherman
blyssz
  • Locked
  • Question
Olap Cube Using Project Server 2007
Replies
0
Views
87
blyssz
blyssz
Phe0nix
  • Locked
  • Question
Dimensions with Inclusive Members
Replies
0
Views
84
Phe0nix
Phe0nix

Part and Inventory Search

Sponsor

Back
Top