Skip to Content
0
Former Member
Sep 06, 2010 at 05:25 PM

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

22 Views

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