I think Chris Webb explains the issue, and potential work arounds, better than I could. It's here[/url].

On rereading what you want, that actually may not be right.

Not saying its simple, but I think the hierarchesize function is what you need to use.

You should be OK if you've used a surrogate key for the dim key, you should be able to do a refresh (versus full process) of the dim, meaning this...

Good point - just to clarify, the collation you reported, is that the SQL collation or the SSAS collation?

And in case it's not clear, the last few letters of the collation - CI, AS - refer to Case Insensitive and Accent Sensitive (respectively), and the alternates are CS...

Hey Jon, if you already have the dimension created and you're just missing the P-C, then make sure the parent attribute is in the dimension ( this is the SSAS...

Also, are your facts correct? Ie unless you have some other measures, you'd not normally have a fact record where a "fact" (ie "was a student") doesn't exist. From...

When you create measure, you can set the aggregation (Sum, Count, distinct count, min, max, average etc). Simply trying to find out what your measure is set to.

When viewing...

Jon,

It sounds like you've modified the join/table in the DSV but not the dimension (on the attribute dimension) itself. In the dimension, if you right click on the attribute...

So you've set Fact_SEN_CHILD as a measure? If so, what is the aggregation type set to?

Also, if you right click in the DSV and view data, what...

Maybe I missed it, but can't you remove the user group/s from the SSAS DB and script this action and then add them back in and script this action. ...

I would argue that many people leave a lot of SSAS functionality on the table's and never use it for more than simple cubes, but that's a different topic for...

You should be able to use the Precedence Constraint with the addition of an evaluated expression - basically like using a 'green' arrow (ie continue on if the prior stage...

hi friends,

plzz share ur knowledge regarding my doubts..

1.do we have different kinds of cubes in ssas( today i came to know a word 'local cube' ), what does it means?

2....