Regarding values restricted in Filters in Query Designer

[former_member317899]

Hi,

I have restricted a characteristic "Tax Category" with four values(ZMW1,ZMW2,ZMW3,ZMW4) in "Characteristic Restrictions".

In the rows,I have included this characteristic as well.

Now,when I am executing the query,I see the characteristic values for only two of it.

How shall I get the 4 values displayed in the rows of the report.

Please guide me.

Thanks & regards,

Manjari.

[Former Member]

Hi,

plz drag these resriction in default values also.

hope this helps.

Regards,

Sai.

[Former Member]

If you have restricted a keyfigure on tax category = (ZMW1,ZMW2,ZMW3,ZMW4), and data is available only for ZMW3,ZMW4 then ZMW3,ZMW4 will only be seen in the report

[Former Member]

Hi Manjari,

It sounds like you don't have 'posted' values against all 4 tax categories.

Is it possible that there is no data behind the 2 missing categories?

Please check that there are values to display

Rgards,

Karen

[anshu_lilhori]

Hi,

Please check the data in cube for the same restriction what you have done at qeury level.

There might be a possibility that data is not available for that particualr condiiton so for the same reason it is not displaying in query also.

Also check for other filters and restriction at query levels.

Please try to analyze and compare the query design with cube output,it will help you in analyzing the issue in a much better way.

Hope it helps.

Regards,

AL