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!

SemiAdditive or Non Additive

Status
Not open for further replies.
Dabbs

Dabbs

Programmer
Jun 3, 2008
1
US
We have a field in Fact table which should be availble at all level but should never be AGGREGATED at any level.

We tried AggregatedFunction value as NONE but that removes the field from being displayed browser.

We are using Analysis Service 2005.

 
Sort by date Sort by votes
what type of data is the field? You might try first child or last child. It really depends on the situation.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Rolaper
  • Locked
  • Question
MDX Calc measure to accomdate Smi-Additive and delta SCD at the same time?
Replies
0
Views
99
Rolaper
Rolaper
RiverGuy
  • Locked
  • Question
Measure group containing Additive and Semiadditive measures 1
Replies
3
Views
54
RiverGuy
RiverGuy
eo
  • Locked
  • Question
MDX Calc measure to accomdate Smi-Additive and delta at the same time? 1
Replies
5
Views
101
eo
eo
petersJazz
  • Locked
  • Question
MDX Filter or Except
Replies
0
Views
71
petersJazz
petersJazz
flurk118
  • Locked
  • Question
Semi-additive issue...
Replies
7
Views
58
flurk118
flurk118

Part and Inventory Search

Sponsor

Back
Top