and getting down to the details - yes, even if you don't have an aggregate, the sum measure will still work. You'll be expecting/asking the engine to calculate that...

If I open the solution that I created for the cube, the partitions I added dynamicly will not appear in the solution and would be overwirtten, when I would deploy...

If you want to use the Campaign as the filter element, then as I see it, you'd want to implement many-to-many. The reason being, your campaign has two (2)...

Hmmm, extremely similar thread - si there a college problem we're all now trying to solve or folks are using multiple accounts maybe?? :hehe:

Regardless, although on the other thread...

Thinking on this a little more, I think you may have a Classic many-to_many, as defined by Marco Russo et al (download their whitepaper here[/url]).

If you look at their example,...

Need a little more info (like how is DimX related to the time dimension, doesn't appear to be any PK-FK relationships there).

Having said that, if DimX is in...

Is there nothing else returned? It doesn't look like you've pasted the error, just the call stack (ie SSAS telling you where in the stack the error occurred).

Have you started the browser service on your machine? can't remember the exact circumstances but i think when using a named instance, because te port numbers are not standard...

Glad to hear that it worked. Just one quick test I would look at doing is to have that sample set return *two* rows, and that you get as output...

At a conceptual level, you need to have a group, and then force a page break per grouped item. The group would likely be 'student'. Am reasonably sure...

Not quite following... so you've tried one of the approaches above, and they didn't work? Or you're yet to try one of the approaches and you'll let us know?

Assuming...

You could use an expression in the report, from memory, they support a lot of VB/VB.net functions, which are sure to include either a strconv (string convert) function or a...

If it's truly that high level, and you don't want to 'document the software', then you have a source-to-target mapping document right? this is what you used to build...

How are you testing? If you're trying to test using your admin account, you'll see everything.

Hi Brian,

I've not performed a trace to disprove this, but it sounds like SSAS is doing what it needs to do - if you want these data items in the...