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

Manipulating datasource while launching Chart

Hello ,

I have a req where I have 3 tabs in a report, and Time dimension as selection for all the charts in 3 tabs.

Account Actual Busget 2011004 500000 4600000 25100 456789 654678

In one of the tabs I have

Tab1 Tab2 Tab 3 Revenue Overall Capital

Each tab has a chart. While doing data binding in Time Property,Target data sources, I gave 3 charts. Therefore when I select any time it effects all charts. This works fine.

now I wan to manipulate my chart in such a way that, if I select August in time dim..it shld only Pass Actual until August and from August everything should be Budget. So I need to somehow know the values selected, I tried OnApply events on Time dimension. I need to some how pass these to only restrict to Actual.

Any help please;

Regards,

Krishna

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Sep 10, 2014 at 05:14 PM

    Hi,

    do I understand you correctly?

    you want to filter on 3 data sources (bound to 3 charts), BUT when filtered (onApply event) you want to make additional sub-filtering to distinguish Actuals (<= today) and Budget (> today)?

    if this is correct, you have to check what date is today and then rework the filters. for the date manipulation you can use

    then, on every data source you can apply script "DS_X.setFilter(...);"

    Of course some additional scripts will be required to calculate the correct filters per data source.

    if it is not correct, you would need to describe more details and make some screen shots.

    Regards, Karol

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      you almost got what I wanted. Its not on date but on a Period, Quarter, Year etc. which are BPC time dimensions which is a Dimension Filter property.

      So Its a Heirarchy which is assigned to a field in the report. User can select one month / Period etc. I want to capture what is selected e.g if more than one month is selected, and then Pass that value as input to the Datasource for the chart in the Data selection area of the data binding..

      If it is any clear now. I checked all the API functions which can be used with Dimension Filter property but could not find any function to return the dynamic selected values at runtime.

      Regards,

      Krishna

  • Posted on Sep 10, 2014 at 06:01 PM

    ok, then have you tried to use the method:

    String DATA_SOURCE.getFilterExt(dimension)

    this brings you the selection as string, but you need to parse it.

    possibly, you will need a fourth data source which you can bind to the filter dialog and then try to make following script:

    String selection = DS_4.getFilterExt("DATE");

    // here you have to parse the selection, you can use the script to check the value:

    APPLICATION.createErrorMessage("Selection : " + selection);

    // and then you can modify and pass to your other data sources:

    DS_1.setFilterExt(newSelection);

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Karol Kalisz

      Thanks Karol anyway..exactly that is what I wanted. Yes I may need to take help of CSS..

      Need to explore that side of the coding..I will search but if you can say any pointers..please let me know.

      Kind Regards,

      Krishna

  • Posted on Sep 11, 2014 at 01:54 PM

    Hi,

    Is it based on a bex report, I think best way is to create a rcombination with a resticted keyfigure and calculated KF, with the variable (selection) in it.

    When you fill the variable on runtime, it wil show the correct numbers directly. Data manipulation is not well suported in DS.

    Grtz

    Koen

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Koen Hesters

      Hello.

      Exactly. I know. we are also doing POC, when SAP releases atleast 2 versions DS from 1.1 to 1.3 (we are using 1.3) I assume they would be mature as a product to the customers. SAP is having a stack of tools for reporting. All one needs is to reduce the systems in stack and have a uniform look and feel. The more tools you have in the stack, the more work for maintenance e.g. Heirarchy authorization that we configure in RSECADMIN, how to handle the same in all these layers..

      Anyway someone in SAP notices and gets a solution, its a hope.

      Yeah I have that in mind as a last resort to try and deal in Bex.

      Regards,

      Krishna

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.