WHat process did you take exactly to nominate/get the R2 bits plus Gemini? We went through connect (for R2) and there was a questionairre for self nomination for Gemini....

Hey Arunkumar,

That error alone doesn't really tell us much (ie makes it haard to determine what might/could have gone wrong). Going back first to the Dimension Usage tab, did you...

Go to the dimension usage tab in the cube designer and review the join/relationship between your fact table {measure groups} and your dimension table/s, it looks like the relationship/s are...

A key piece of OLAP structure that you're missing (or at least not referring to) are hierarchies. You would normally present the user with hierarchies that enable them to...

@marianne - i like that approach, neat

@eddy - glad it worked for you

Are you on the SQL 2008 R2 beta? It's in CTP now so you should be able to download it freely. If you check out some of the...

Sorry, SSAS is only available with Standard and Enterprise 🙁 Details of features in each edition are here.

The "Advanced Features" in Express Advanced are:

- Basic installation of SQL Server...

Just out of interest, did you try publishing the report and viewing the result there? MSDN indicates that this property is "not available in local preview" for both...

While you're making lists of arguments for DB's and against Excel, seeing as you have an incumbent technology (MIS Alea) I would also quickly review their website and note their...

Eddy,

You could try the following as an expression in a textbox - you simply have to name your DS, you had mentioned 'datasource1' earlier, so i used that -->

DataSources("datasource1").DataSourceReference

This will...

Something that may have been a typo, but if you copied your code directly, shouldn't "red" be "Red"?

Little bit unclear as to exactly how you're implementing this, but going on assumptions again -> assuming that the paramters were prob created by SSRS for you, then they're likely...

It's hard to give you exact answers as we don't know all of your specifics, but an approach like the following should, in theory, work.

Assuming measures M1 and M2 are...

It depends a lot on the data you have available in SSAS (and other accessible sources) but some things that come to mind:

- classification/decision tresss-> using something like total project...

It's a little hard to tell, but it sounds like you may have a 'many-to-many' business requirement here (and definitely sounds like you are either missing relationships between your facts...