cancel
Showing results for 
Search instead for 
Did you mean: 

How can I reduce the selection for the characteristics value in a BW query

Former Member
0 Kudos

Good morning,

I need to find out how I can reduce the selection for the characteristics values in a BW query.

In a BW query I have a characteristic "Due month".

The characteristic values shown in the query are from 01.2001->03.2007. I would like to reduce it to the last 2 years,in the query view, without deleting the data for the other years in the cube.

Do you know how this can be done?

Thank you in advance for your feedback.

Kind regards,

Linda Verding

Staff Consultant - CSC

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi,

First thing you have to do is check the report how the data is being restricted only to those months.

1) one it can be variable in which the code is written for that to populate for last few years.

or else it must have been hardcoded for these months.

Go into your report and underneath the characteristicsCALMONTH there must be an variable or hardcoding.

You need to change this here in the report.

You dont have to delete anything there.

Regards, Siva

Former Member
0 Kudos

Hello,

Thank you.

I will look into it.

I don't like to hard-code the calendar months in the report.

Kind regards,

Linda

Answers (2)

Answers (2)

former_member188325
Active Contributor
0 Kudos

Hi,

It may be possible with authorization concept also where authorized users will be able to see only last 2 years .

thanks

Former Member
0 Kudos

Hi,

Thanks.

I will check if this can be done.

Kind regards,

Linda

Former Member
0 Kudos

Hi,

Not sure if it is possible as the only settings you can make are :

1. Only posted values in Navigation

2. Only values in Infoprovider

3. Values in Master Data Table

Former Member
0 Kudos

Hello,

Thank you.

I will check it.

I think it might help if I select "Only posted values in Navigation" for Info object "0CALMONTH".

Kind regards,

Linda