I must confess I didn't quite understand SSChasing Mays post. As to the how much of the Cognos environment is supported with MSAS cubes, I'll defer to someone who's looked...

There's actually a whole series of front end or tools. Third party tools (Like Cognos, Business Objects, etc.) are good as well, but be warned, each tool / environment fits...

Persist, it gets better.

To load dimension information, I recommend you use the slowly changing dimension transform. I use it for all dimension tables, and it works find. Caution: although this...

I know you said you had no staging tables, but depending on what you're doing, I suggest you reconsider this idea. SSIS is great (I use it heavily), but for...

I'm assuming you are using the standard MS Access table view. That's just the standard behavior of Access. (Nothing to do with SSIS.)

Close / open the table again.

500++ tables in a data warehouse is truely massive for a data warehouse (not for a OLTP database). I'd get someone to take a look over your shoulder at your...

I suggest you look at loading your data into MSAS. Pivot table services is designed to work directly with MSAS. Some caveats:

- Pivot table services won't let you create calculations....

While actually, you'll find this a better (correct??) implementation. It doesn't have anything to do with your MDX skills:

- In general, approach cube design by ensuring you have aggregatable facts....

try

=IIF(me.value <0, "RED","GREEN")

I think you are looking for the keyword "Me" (As in "Me.Value"). Don't try to display it in the contents of the text box, because you'll get an error (recurssion...

I don't expect you'll be able to get this to work:

- You have a number of dimensional attributes that are referenced on both the columns and the rows. You...

You shouldn't need to use LinkMember. If I'm reading your dimension information right, you probably should be including [Packing Group] as part of [Current Items] dimension. Alternatively, you could build...

First, create your query to convert your "yes" answers to a number (i.e. When "Yes" then 1 else 0). I'd suggest putting it into a view, then doing a standard...

Another suggestion would be to push the formula up to the Report Level, then have each of the text boxes reference it there. The code editor is terrible there (why...

Again folks, add some more details. It's tough to respond unless there's some meat on the bones.

I'll assume you're looking for the MDX syntax to reference previous month. If not,...