Cognos Analytics

Hi,

I'm assuming the report is built over a dimensional package? Can you be a bit more specific about what you are doing? You mention filtering, but is this via a dimensional filter function in an expression, or are you using detail filters? Would the set of members you want to see in Level 2 be static, or would they change over time?

Cheers!

MF.

package. This is the query that i use to filter the level:
Where "Contesto esterno" is the level1 and "Variabili" is the level2.
I use the detail filter to remove the wrong elements.

After that query, i use another simple query linked to the first one to fetch the distinct items.

Let me know if that's clear enough
Thank you,

Valerio 

Hi,

I'm assuming the report is built over a dimensional package? Can you be a bit more specific about what you are doing? You mention filtering, but is this via a dimensional filter function in an expression, or are you using detail filters? Would the set of members you want to see in Level 2 be static, or would they change over time?

Cheers!

MF.

Hi,

Using detail filters with a dimensional package something I always advise caution over. Detail filters are a relational reporting concept, and can often deliver results that are incorrect when used with a dimensional source.

You mention originally that you are using a tree prompt? Usually you'd feed this with a set of members. It looks like you need the members at level 1 filtered based on a measure value? Do you have the same requirement for members at level 2 also?

For filtering a set of members, rather than using a detail filter, I would suggest you use a dimensional expression for the set, eg

filter([your set of members], [your measure] > 3)

I'm still not clear on how you need your tree prompt to be populated, though. Can you provide more detail?

Cheers!

MF.

package. This is the query that i use to filter the level:
Where "Contesto esterno" is the level1 and "Variabili" is the level2.
I use the detail filter to remove the wrong elements.

After that query, i use another simple query linked to the first one to fetch the distinct items.

Let me know if that's clear enough
Thank you,

Valerio 

Hi,

I'm assuming the report is built over a dimensional package? Can you be a bit more specific about what you are doing? You mention filtering, but is this via a dimensional filter function in an expression, or are you using detail filters? Would the set of members you want to see in Level 2 be static, or would they change over time?

Cheers!

MF.

Hi,

Using detail filters with a dimensional package something I always advise caution over. Detail filters are a relational reporting concept, and can often deliver results that are incorrect when used with a dimensional source.

You mention originally that you are using a tree prompt? Usually you'd feed this with a set of members. It looks like you need the members at level 1 filtered based on a measure value? Do you have the same requirement for members at level 2 also?

For filtering a set of members, rather than using a detail filter, I would suggest you use a dimensional expression for the set, eg

filter([your set of members], [your measure] > 3)

I'm still not clear on how you need your tree prompt to be populated, though. Can you provide more detail?

Cheers!

MF.

package. This is the query that i use to filter the level:
Where "Contesto esterno" is the level1 and "Variabili" is the level2.
I use the detail filter to remove the wrong elements.

After that query, i use another simple query linked to the first one to fetch the distinct items.

Let me know if that's clear enough
Thank you,

Valerio 

Hi,

I'm assuming the report is built over a dimensional package? Can you be a bit more specific about what you are doing? You mention filtering, but is this via a dimensional filter function in an expression, or are you using detail filters? Would the set of members you want to see in Level 2 be static, or would they change over time?

Cheers!

MF.