What function to be used for conversion from value to a member

[inu]

Hi Team,

Please suggest me on below error, what step should i take.
I used the detail filter as  [Fact KPI Summary Monthly (Analysis)].[Regions].[Region].[Region]=?R?

XQE-PLN-0115

      An invalid value was assigned to Prompt 'R'. The prompt expects a member from level [Agreement Fact - Monthly (Analysis)].[Branch].[Region].[Region], but the value assigned is a member from level [Fact KPI Summary Monthly (Analysis)].[Regions].[Region].[Region].


Regards,
Inam

[Lynn]

I used the detail filter as  [Fact KPI Summary Monthly (Analysis)].[Regions].[Region].[Region]=?R?

Take a look at these posts which explain (directly to you) why detail filters should not be used with dimensional sources.
http://www.cognoise.com/index.php/topic,32211.msg105385.html#msg105385
http://www.cognoise.com/index.php/topic,32160.msg105065.html#msg105065

If you don't listen to things people tell you (repeatedly in some instances) then they may stop responding.

[inu]

Take a look at these posts which explain (directly to you) why detail filters should not be used with dimensional sources.
http://www.cognoise.com/index.php/topic,32211.msg105385.html#msg105385
http://www.cognoise.com/index.php/topic,32160.msg105065.html#msg105065

If you don't listen to things people tell you (repeatedly in some instances) then they may stop responding.

Hi Lynn,
Thanx. I read that , still i cant resolve the issue. Why i used detail filter because dont know how to use in slicer, apart from this in slicer that will be required, which i dont want.

But i will do as you people suggested, i will search to make slicer optional, and how to use [Fact KPI Summary Monthly (Analysis)].[Regions].[Region].[Region]=?R?.

Lynn, I am developing a dashboard which has lots of functionalities and interactivities with other reports in portal page using DMR only.
One more issue came into picture, how to get top ten rank, in relational we were using rank() simply, which cant be used here.

[BigChris]

Take a look at the Dimensional Functions in report studio - you should be able to find something in there...

[MFGF]

Hi Lynn,
Thanx. I read that , still i cant resolve the issue. Why i used detail filter because dont know how to use in slicer, apart from this in slicer that will be required, which i dont want.

I'd suggest (again) that you take some training, inu. It will make your life SO much easier if you understand what you're doing.

Using detail filters with dimensional sources is a BAD BAD BAD idea. Don't do it. If you want a specific region to be displayed, add a query calculation to your crosstab/chart that displays the desired region ie [your Region hierarchy] -> ?R?. You can add a default selection to the prompt that has the MUN of the All Regions member, so you will see All Regions by default.

One more issue came into picture, how to get top ten rank, in relational we were using rank() simply, which cant be used here.

The dimensional equivalent is to use a query calculation utilising the topCount() function.

MF.

[inu]

I'd suggest (again) that you take some training, inu. It will make your life SO much easier if you understand what you're doing.

Using detail filters with dimensional sources is a BAD BAD BAD idea. Don't do it. If you want a specific region to be displayed, add a query calculation to your crosstab/chart that displays the desired region ie [your Region hierarchy] -> ?R?. You can add a default selection to the prompt that has the MUN of the All Regions member, so you will see All Regions by default.

The dimensional equivalent is to use a query calculation utilising the topCount() function.

MF.

thanks.
I dont want to use detail filter, that's y asking you expert personnels.
I got top 10 rank using topCount([State] level, 10, meaure).
Trying to make slicer as optional prompt.





Regards,
Inam

[MFGF]

thanks.
I dont want to use detail filter, that's y asking you expert personnels.
I got top 10 rank using topCount([State] level, 10, meaure).
Trying to make slicer as optional prompt.





Regards,
Inam

Can you explain why you are using a slicer? Doesn't the advice I gave above about using a query calculation work? Can you provide more detail?

MF.

[inu]

Can you explain why you are using a slicer? Doesn't the advice I gave above about using a query calculation work? Can you provide more detail?

MF.

I attached snap shot of  query items.
In chart i am going to use Representation Frequency in categories, state in series, and % Growth in Disbursement Amount in measure box.
I used query calculation and named it Region Hierarchy ([Fact KPI Summary Monthly (Analysis)].[Regions].[Region]->?R?), what you told me. Why i need this because in bubble chart regions are displaying, if user clicks on any region its value will reflect this chart and show top ten state value(i-e one level down). But i have one dought. that region and state both are in one query wont it affect the value. that's it.

I used below statement for default, please check once.
[Fact KPI Summary Monthly (Analysis)].[Regions].[Region]->:[PC].[@MEMBER].['+prompt('R','token','Region')+']'#


Thanx.