Unique Levels in DMR

[kado]

Hello,

I have a DMR model that doesn't appear to be grouping my data as desired. For instance, I have a hierarchy called Product with the following levels:

- Prod Division
- Prod Type
- Prod #

Prod Type is not unique in that it can show up in multiple divisions. With that, I would like Prod Type to display uniquely when presented to an end user in the form of a prompt. It always shows all of the overlap and looks to be displaying the same Prod Type over and over (because they show up in multiple divisions).

any thoughts?

thanks,
kado

[cognostechie]

Are you creating the prompt from the DMR itself ?

I usually create seperate query subjects to act as lookup tables for prompting. This also ensures that the Prompt page comes up fast without the user having to wait for the the DMR/Full Query subject to execute.

Create a seperate query subject to include only the Prod Type and it's Description (if reqd). You can either use the 'group by' function in the SQL or use Determinants and group it to show the value only once. Use this Query subject to populate the prompt.
Check the filter in the report and if required, change the filter condition to compare the value of the DMR level with the value in the Prompt.

[cognostechie]

Sorry, what I meant was that you can create a seperate query subject by using the Prod Type master table as the source. That way you don't even have to group it because the master/dimension table in the DB might have unique values for the Prod Type. 

[kado]

I am trying to create the prompt from the DMR model and appreciate your feedback. That makes sense.

thanks,
kado