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

No relationships between measures and dimensions - do I have any contr

Status
Not open for further replies.
eo

eo

MIS
Apr 3, 2003
809
No relationships between measures and dimensions - do I have any contrrol over its display?

As we all know, when there is no relatinship between a measure and a dimension, when a user tries to slice such a measure by that dimension, then the measure grand total is repeated for every dimension member. Could this rather revert to NULL. Or any other sensible solution that will highlight to the users that he/ she is doing an illegale slice?

EO
Hertfordshire, England
 
Sort by date Sort by votes
Set IgnoreUnrelatedDimensions to false for your measure group that you want for your nulls.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Motlatjo
  • Locked
  • Question
All Dimensions showing on Excel, but only 3 showing on SSMS
Replies
0
Views
143
Motlatjo
Motlatjo
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
140
juanvg1972
juanvg1972
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
173
JP_Quinn
JP_Quinn
jbluedelta
  • Locked
  • Question
OLAP over HTTP and 503 error and connection time out
Replies
0
Views
167
jbluedelta
jbluedelta
burakcan
  • Locked
  • Question
How to rounding up to next integer value In MDX
Replies
0
Views
165
burakcan
burakcan

Part and Inventory Search

Sponsor

Back
Top