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 derfloh 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
Joined
Jun 3, 2008
Messages
1
Location
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 Question
MDX Calc measure to accomdate Smi-Additive and delta SCD at the same time?
Replies
0
Views
501
Rolaper
Rolaper
RiverGuy
  • Locked
  • Question Question
Measure group containing Additive and Semiadditive measures
Replies
3
Views
309
RiverGuy
RiverGuy
eo
  • Locked
  • Question Question
MDX Calc measure to accomdate Smi-Additive and delta at the same time?
Replies
5
Views
553
eo
eo
petersJazz
  • Locked
  • Question Question
MDX Filter or Except
Replies
0
Views
287
petersJazz
petersJazz
flurk118
  • Locked
  • Question Question
Semi-additive issue...
Replies
7
Views
313
flurk118
flurk118

Part and Inventory Search

Sponsor

Back
Top