Arggh, smileys gone wild... just imagien the wink is a closing bracket and it reads sorta ok...

Rick,

Are they actually two different products, or the same product you want to see under two different parents in the hierarchy?

If they truly are two different products then I'm not...

You can introduce/query data from different cues in a single statement but I think you'd have to use the LookUpCube function (which has performance implications?). Assuming you've got the SQL...

Hey Daniel,

If you have the one dimension set up in your project, then go to the Cube Structure tab (when editing the cube) and in the Dimensions pane, right click...

hey Daniel,

Are you using 2005 or 2000? In 2005 you can use a single time dimension (or any dim really) as a Role Playing dimension, so you create it...

Do you get the same result when you filter the two dimensions down to individual dates (you had previously used 2007-08-01 and 2007-08-04)? I guess another pertinent question is...

Have you tried replacing the pluses with ampersands? so ...WK NBR].[' & " & CStr(Parameters!prmStartWeek_INT.Value) &" & ']

If you look at the AS2005 Performance Guide (google showed me a pdf copy here), skip down to page 82 (heading is Availability Settings) you'll see the answer to at...

I would tend to agree that your design is better, the other design would appear to make it much more difficult to generate meaningful results for an average end user.

I...

Looks like you're stringing together a dynamic mdx statement in RS (hence the additional quotes). The real issue (the one causing your error) looks to be that you have...

Arati,

If it started working after changing the AppPool i would definitely be thinking 'security', or more precisely, the account that was running AppPool2 didn't have the same permissions as the...

Sounds feasible. The should be no (well, few) issues in calling a web service from langauge A where the web service is written in Language B (this is one...

sthanika,

When you dbl-click to bring up the properties of the datasource,there's two tabs,the first 'General' contains the connection string etc, the second 'Account Impersonation' is used to specify how the...

Could be a typo on your post but I'm guessing it could be case sensitivity on the param name that you pass using -v.

you wrote

(note the lowercase...

may be taking your example too literally, but is there a reason why you can't add a new attribute to the dim, have this effectively be a flag as to...