Need help for report Variable to restrict the key figure value...

[Former Member]

Hai gurus,

Now i have data in the cube as follows...

Reuisition HR INTW date LM INTW DATE TEL INTW DATE HR Count LM Count TEL Count

a1 01.01.2010 02.01.2010 01.04.2010 1 1 1

a2 02.02.2010 03.02.2010 02.02.2010 1 1 1

a3 03.03.2010 04.03.2010 03.03.2010 1 1 1

when i execute the report it shd ask the prompts with Date interval as in the below...

HR INTW date

LM INTW DATE

TEL INTW DATE

if i dont give any interval in the variable prompt it should display all the recors as follows

Reuisition HR Count LM Count TEL Count

a1 1 1 1

a2 1 1 1

a3 1 1 1

If i give LM INTW DATE interval as 01.01.2010 to 31.02.2010

then it should display all the other counts as in the output_1 , but for LM count for a3 it should show 0.

Reuisition HR Count LM Count TEL Count

a1 1 1 1

a2 1 1 1

a3 1 0 1

that means wherever i restrict the data depending on the variable that only that interval key figure value shd be in the report..

for this scenario, which variable i need to use... and how i need to restict the KFig value in the report...

Right now i am getting like this but it is restricting the records,,, where it should not restrict the records...in the report..

Please guide me for the same...

If any concerns about the scenario please let me know...

Regards,

VJ

[Former Member · Accepted solution]

Hi,

You can achieve this very easily. In Query Designer for this report, you need to create 3 characteristics variables of 'Default/ User entry' type. One each for

HR INTW date LM INTW DATE TEL INTW DATE

In all these the characteristic variable, select the option for 'Ready for Input' and keep them as Select-option type.

Then restrict the keyfigures based on these variables.

Restrict HR Count by variable on HR INTW date

Restrict LM Count by variable on LM INTW DATE

Restrict TEL Count by variable on TEL INTW DATE

Save the query and execute it. A pop-up would come where you can input your value for dates.

[Former Member]

Hi,

This can be achieved.

First create 3 User input variables as selctyion option/range (as per your need).

Now do not restrict query globally with these variables on those dates.

Create 3 RKFs for your 3 counts (HR/LM/TEL). Use the appropriate data charactereistics in these RKF definition (for LM restrict with LM date and put the user input variable for LM date as restriction).

Now display these 3 Restricted Key figures (RKFs for LM/HR/TEL) in query.

This will pop up 3 selction variables for 3 dates while executing query, you may put any range in any variable. As per you given slection it will restrict the values of corresponding RKF and display the rest.

I hope it will help.

Thanks,

S

[Former Member]

hi chowdary ,

could you tell me the var. creation in detail and with which reference object i need to create ...

whether i need to take LM_DATE / 0DATE while creating variable...

and i kept this variables it in filter section, based on the LM_DATE Object.

..

i have tried both.. y'day when i take 0DATE it giving me some results...

But at the same time it is restricting the records..

i think it could be a problem with var.. properties?

need more inputs pls.

Regards,

VJ

[Former Member]

hai gurus,

here is the solution for my problem...

ofcourse after creating the variables we should not include them in the FILTER Panel....

just create and restrict....

Solution:

you need to create the first variable on the date char in the filter part of the query.

the second one is to be created when restricting the key figure. it should not be present in the filter part of the query.

if you do it like this it should work as you want.

Regards,

VJ