COGNOiSe.com - The IBM Cognos Community

IBM Cognos Express => IBM Cognos Express => Topic started by: jehjasjes on 08 Dec 2010 11:03:59 PM

Title: MDX Query help in Report Studio
Post by: jehjasjes on 08 Dec 2010 11:03:59 PM
Hi,

I am having a dimension called Company as the page layer.

Based on the company selected, I want to update a cell with same company name which is selected.

I tried using query calculation so on. But nothing worked.

Could somebody suggest a solution.

Your help is much appreciated

Kind Regards,
JG.
Title: Re: MDX Query help in Report Studio
Post by: MFGF on 09 Dec 2010 07:45:02 AM
Hi,

I'm not quite clear on exactly what you are trying to achieve.  When you said "Based on the company selected", does this imply you have a prompt for Company?  Or do you mean you want to get hold of the Company value used in the current page?

When you used a Query Calculation, what expression did you use?  What error(s) do you get?

MF.