Prompt when done with 'Cascade source' not showing values for some selection

[asmfloyd]

Hello,
  I have 2 prompts in my report which is used to pull data from a summary table. Example: First prompt for Gender and second for Race.
   When I choose "cascade source" option for second prompt, only for some values of Gender prompt, the 2nd one is returning values. Not for all; as it just shows a "-----" line for some.

If I remove the cascade source option, the 2nd prompt shows values based on any selection from 1st prompt. I am on 10.2 version.

   Any inputs on debugging this? I checked FM and joins are as expected.

Thanks,

[MFGF]

Hello,
  I have 2 prompts in my report which is used to pull data from a summary table. Example: First prompt for Gender and second for Race.
   When I choose "cascade source" option for second prompt, only for some values of Gender prompt, the 2nd one is returning values. Not for all; as it just shows a "-----" line for some.

If I remove the cascade source option, the 2nd prompt shows values based on any selection from 1st prompt. I am on 10.2 version.

   Any inputs on debugging this? I checked FM and joins are as expected.

Thanks,

Hi,

Do you see the same issue if you remove the Cascade Source setting, then filter the query populating the second prompt to return values based on the parameter from the first prompt (ie engineer your own cascade)?

MF.

[asmfloyd]

Yes. I see the same issue now without cascade. What does that convey? OR Am I doing something wrong in prompt creation?
   PS:I have data in my summary table based on both these filters.

Thank you for the help.

[Francis aka khayman]

are both prompts using the same query?

[asmfloyd]

No Khayman. One is for Gender and another is for Race.

[Francis aka khayman]

care to share the data items for each query? i would imagine it would be something like:

Gender = select gender from some_table

Race = select gender, race from some_table

[asmfloyd]

Thank you for the tip to check the query Khayman.

My 2nd prompt query uses a join between 2 dimensions including the fact and unfortunately the join came from the fact used was not the right one due to the incorrect "shortcuts" design at FM.

      Race=select a.gender,b.race from table 1,table b, FACT1 c--while I was requiring FACT 2.

Thanks..

[cognostechie]

The problem is not the shortcut in FM but poorly/hurriedly/short-sightedly designed dimension or maybe there is no dimension but only a collection of Master tables. The gender and race should be part of the same dimension as both are attributes of a person. Joining thru a fact table will result in massive processing which is unnecessary in this case.