how to get the old data in the query

[Former Member]

Hi Gurus

i need to create a query where in the default view the user wants to see the data from Jan' 08 but if required he can always go back and check on the old data. i had earlier used a filter on 0CALMONTH i.e. greaterthan equal to Jan '08 but that does not allow me to navigate on data older than Jan'08. Can somebody please help me on how to go about it.

points will be awarded!!!

[Former Member · Accepted solution]

Hi Anugrah,

In such a case create a characteristic value variable on Cal month, to accept a month from user. Make it defalut to Jan 08.

Use this variable instead of value for restricting in the query.

So by defalut the report will run from Jan 08 and if the user wants he can change the month to something else.

Naveen.A

[Former Member · Accepted solution]

Tnx for all the inputs they were really helpful but a small problem in the characteristic variable itself i have taken the default value as >= Jan 08..but after doing that in the initial output it is showing me the data only for the month of january whereas as per my default value it should me the output for all the months from jan08 to may 08. could anybody tell me if i am missing anything....points are certainly due from my end!!

[Former Member · Accepted solution]

Hi

Create a variable for cal month with interval.

Then set the default value as 01.2008 to 12.2008.

Also check the option Query can be changed during navigation.

Now when you execute the report initially the valriable will be filled with 01.2008 to 12.2008.

If the user need then he can change the values in the variable by selecting the change variable values.

Regards

M.A

[Former Member · Accepted solution]

Hi M.A.

i was successful in getting the initial values as jan08 to dec 08 but upon selection of the variable the second time to get the old value interval i do not get the old values in the selection variable and and second question is where do i check the option "Query can be changed during navigation". I am working on BI 7.

[Former Member · Accepted solution]

Hi

While creating the variable you can find the tow check box one for Ready for input and the other is query can be changed during navigation.

So select both the options.

Now when the user executes initially the variable will be filled with the default value.

01.2008 to 12.2008.

When the user need to see the old data then select the option change variable values and enter the required month in the variable.

This is working fine in 3.5. I hope it should work in Bi 7.0 also.

Regards

M.A

[Former Member · Accepted solution]

Tnx M.A but the second option when creating the variable in BI 7 is "Variable is without context" and not the one u mentioned.

[Former Member]

Hi,

here in filter you have take less than or equal to the given date, i think with this it will work.

[Former Member]

Yes, you should use a varaible rather than filter.

The only problem here is user has to come to the selection screen to enter the value for calmonth to see the history data.

Thanks...

Shambhu

[Former Member]

Hi Anuragh,

Please do as suggested by Anuragh........Create a characteristic variable on 0calmonth and default it to Jan'08 as well user can also input some value also.

Restricting the query on global filter by Jan'08 will not lead the user to select value of his requirement.

Thanks

Dipika