Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2010 at 07:24 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2010 at 02:20 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.