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

Non-Aggregated Calculation on Fact-Table

Status
Not open for further replies.
Greg007

Greg007

Technical User
Sep 7, 2004
4
DE
Hello
I like to multiply to Fields in a row of a fact table.

Working with "Calculated Members" will first aggregate the data within a given group and then multiply the aggregated Fields.

Is there any way to calculate first and aggregate later ?

thx for support
Greg




 
Sort by date Sort by votes
Greg,

If the data is not semi-additive or non-additive, that you should not be a problem. If it is, then the best way to deal with it is through calculated members and no pre-calculations in the DB.

Justin
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
160
juanvg1972
juanvg1972
Motlatjo
  • Locked
  • Question
All Dimensions showing on Excel, but only 3 showing on SSMS
Replies
0
Views
161
Motlatjo
Motlatjo
JP_Quinn
  • Locked
  • Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
197
JP_Quinn
JP_Quinn
scottcabral1979
  • Locked
  • Question
multi leve fact table
Replies
1
Views
85
johnherman
johnherman
RRinTetons
  • Locked
  • Question
Move cube to a new location on the same server
Replies
1
Views
217
blom0344
blom0344

Part and Inventory Search

Sponsor

Back
Top