Triggering events from a chart possible ?

Hi,

I created a chart from a BI query with VC on NW04s. The chart display one column per day, and I would like to enable a click on the chart to trigger a drill down into a specific day in a separate iView. Is this possible ? I only found this functionality described for table views.

Regards, Christian

SAP Managed Tags:
PORTAL Visual Composer

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

This works. Make sure you connect the output of the chart to an input of a data service. Once you do this, make sure the event name connecting these is called the "select" event. Now, when you click on an element in the chart, you can pass it along to the dataservice (don't forget to map your fields on the connection line)...

If you have more issues or need more details, let me know...

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Prakash,

thanks for the helpful answer. The event is now triggered, but unfortunately not only the selected day is transfered, but the hole day range from the chart. Any idea how to solve this ?

Regards, Christian

What is on your axis? For example, if your axis is by day, then that day should be transfered...

The category axis is day ...

Use the flash debugger and post the output of the select event on this forum...

Here is the output for the click:

--- Debug Logger ---

48: [AADW] executeNext(shift plansQueue - length:0)

47: [AADW] executeNext([STEP7])

46: [AADW] schedulePlan(SELECT)

45: [AADW] schedulePlan(GRID1_SELECT)

44: [AADW] raiseEvent(GRID1, SELECT)

43: [AADW] checkStep([STEP7])

42: [AADW] [PLAN4] Repaint GRID1

41: [AADW] executeNext([STEP0])

40: [AADW] Dyn DataGrid GRID1 ignore: COUNT_unit.

39: [AADW] Dyn DataGrid GRID1 ignore: COUNT_currency.

38: [AADW] Dyn DataGrid GRID1 ignore: COUNT_value.

37: [AADW] Dyn DataGrid GRID1 ignore: DB_Time__avg__unit.

36: [AADW] Dyn DataGrid GRID1 ignore: DB_Time__avg__currency.

35: [AADW] Dyn DataGrid GRID1 ignore: DB_Time__avg__value.

34: [AADW] Dyn DataGrid GRID1 ignore: Queue_Time__avg__unit.

33: [AADW] Dyn DataGrid GRID1 ignore: Queue_Time__avg__currency.

32: [AADW] Dyn DataGrid GRID1 ignore: Queue_Time__avg__value.

31: [AADW] Dyn DataGrid GRID1 ignore: Processing_Time__avg__unit.

30: [AADW] Dyn DataGrid GRID1 ignore: Processing_Time__avg__currency.

29: [AADW] Dyn DataGrid GRID1 ignore: Processing_Time__avg__value.

28: [AADW] Dyn DataGrid GRID1 ignore: Network_Time__avg__unit.

27: [AADW] Dyn DataGrid GRID1 ignore: Network_Time__avg__currency.

26: [AADW] Dyn DataGrid GRID1 ignore: Network_Time__avg__value.

25: [AADW] Dyn DataGrid GRID1 ignore: GUI_Time__avg__unit.

24: [AADW] Dyn DataGrid GRID1 ignore: GUI_Time__avg__currency.

23: [AADW] Dyn DataGrid GRID1 ignore: GUI_Time__avg__value.

22: [AADW] Dyn DataGrid GRID1 ignore: Server_key.

21: [AADW] Dyn DataGrid GRID1 ignore: Server.

20: [AADW] checkStep([STEP0])

19: [AADW] [PLAN4] Copy BWQ2.OUTPUT -> GRID1

18: [AADW] executeNext([STEP0] pending:1)

17: [AADW] executeNext([STEP6])

16: [AADW] Number of rows in OUTPUT is: 1

15: [AADW] Threshold number of rows is:

14: [AADW] schedulePlan(SELECT)

13: [AADW] executeNext([STEP0] pending:2)

12: [AADW] executeNext([STEP6])

11: [AADW] Sent request: <Request type="BW_EXECUTE_QUERY" system="SAP_BW" suppress_results="false" maxrows="500" ><Object id="V2" type="VW" name="" techname="ZAS_WORKLOAD_SERVER" uniquename=""/><Objects type="INPUT" shape="OBJ" role="INPUT"><Object type="INPUT_FIELD" id="WEBAPI" appName="WEBAPI" mapped="0" value=""/><Object type="INPUT_FIELD" id="Client" appName="0CCMMANDT" mapped="0" value="" properties="axis:FREE"/><Object type="INPUT_FIELD" id="Organizational_Unit" appName="0CCM_ORGU" mapped="0" value="" properties="axis:FREE"/><Object type="INPUT_FIELD" id="Calendar_Day" appName="0CALDAY" mapped="1" value="20060722;20060723;20060724;20060725;20060726;20060727" properties="axis:FREE"/><Object type="INPUT_FIELD" id="Calendar_Year_Month" appName="0CALMONTH" mapped="0" value="" properties="axis:FREE"/><Object type="INPUT_FIELD" id="Transaction" appName="0CCMTCODE" mapped="0" value="" properties="axis:FREE"/><Object type="INPUT_FIELD" id="Applic__Component" appName="0CCMAPCO" mapped="0" value="" properties="axis:FREE"/><Object type="INPUT_FIELD" id="Time_Range" appName="0CCMATIRA" mapped="0" value="" properties="axis:FREE"/><Object type="INPUT_FIELD" id="Server" appName="0CCMAPSRV" mapped="0" value="" properties="axis:ROWS"/><Object type="INPUT_FIELD" id="User" appName="0CCMUSRID" mapped="0" value="" properties="axis:FREE"/><Object type="INPUT_FIELD" id="Report" appName="0CCMREPO" mapped="0" value="" properties="axis:FREE"/></Objects><Objects type="OUTPUT" shape="SET" role="OUTPUT"><Object type="OUTPUT_FIELD" id="Server" appName="0CCMAPSRV" presentation="TEXT"/><Object type="OUTPUT_FIELD" id="Server_key" appName="0CCMAPSRV" presentation="KEY"/><Object type="OUTPUT_FIELD" id="Server_ext_key" appName="0CCMAPSRV" presentation="EXT_KEY"/><Object type="OUTPUT_FIELD" id="GUI_Time__avg" appName="D3WB74EO3D8KYF75F3BIOVYLF" presentation="TEXT"/><Object type="OUTPUT_FIELD" id="GUI_Time__avg__value" appName="D3WB74EO3D8KYF75F3BIOVYLF" presentation="KEY"/><Object type="OUTPUT_FIELD" id="GUI_Time__avg__currency" appName="D3WB74EO3D8KYF75F3BIOVYLF" presentation="CURRENCY"/><Object type="OUTPUT_FIELD" id="GUI_Time__avg__unit" appName="D3WB74EO3D8KYF75F3BIOVYLF" presentation="UNIT"/><Object type="OUTPUT_FIELD" id="Network_Time__avg" appName="C65U9DA4UG6UPM4GW5N2SKCIM" presentation="TEXT"/><Object type="OUTPUT_FIELD" id="Network_Time__avg__value" appName="C65U9DA4UG6UPM4GW5N2SKCIM" presentation="KEY"/><Object type="OUTPUT_FIELD" id="Network_Time__avg__currency" appName="C65U9DA4UG6UPM4GW5N2SKCIM" presentation="CURRENCY"/><Object type="OUTPUT_FIELD" id="Network_Time__avg__unit" appName="C65U9DA4UG6UPM4GW5N2SKCIM" presentation="UNIT"/><Object type="OUTPUT_FIELD" id="Processing_Time__avg" appName="C5864IHN09URT9UM3RM8F8C6B" presentation="TEXT"/><Object type="OUTPUT_FIELD" id="Processing_Time__avg__value" appName="C5864IHN09URT9UM3RM8F8C6B" presentation="KEY"/><Object type="OUTPUT_FIELD" id="Processing_Time__avg__currency" appName="C5864IHN09URT9UM3RM8F8C6B" presentation="CURRENCY"/><Object type="OUTPUT_FIELD" id="Processing_Time__avg__unit" appName="C5864IHN09URT9UM3RM8F8C6B" presentation="UNIT"/><Object type="OUTPUT_FIELD" id="Queue_Time__avg" appName="A1544CC21FYAZWK7BBQAN0DH9" presentation="TEXT"/><Object type="OUTPUT_FIELD" id="Queue_Time__avg__value" appName="A1544CC21FYAZWK7BBQAN0DH9" presentation="KEY"/><Object type="OUTPUT_FIELD" id="Queue_Time__avg__currency" appName="A1544CC21FYAZWK7BBQAN0DH9" presentation="CURRENCY"/><Object type="OUTPUT_FIELD" id="Queue_Time__avg__unit" appName="A1544CC21FYAZWK7BBQAN0DH9" presentation="UNIT"/><Object type="OUTPUT_FIELD" id="DB_Time__avg" appName="008RJ3DK8RQ1AZRK9EZ7HX4HU" presentation="TEXT"/><Object type="OUTPUT_FIELD" id="DB_Time__avg__value" appName="008RJ3DK8RQ1AZRK9EZ7HX4HU" presentation="KEY"/><Object type="OUTPUT_FIELD" id="DB_Time__avg__currency" appName="008RJ3DK8RQ1AZRK9EZ7HX4HU" presentation="CURRENCY"/><Object type="OUTPUT_FIELD" id="DB_Time__avg__unit" appName="008RJ3DK8RQ1AZRK9EZ7HX4HU" presentation="UNIT"/><Object type="OUTPUT_FIELD" id="COUNT" appName="7MNISYRDXXHN07SUPVJMJ26N7" presentation="TEXT"/><Object type="OUTPUT_FIELD" id="COUNT_value" appName="7MNISYRDXXHN07SUPVJMJ26N7" presentation="KEY"/><Object type="OUTPUT_FIELD" id="COUNT_currency" appName="7MNISYRDXXHN07SUPVJMJ26N7" presentation="CURRENCY"/><Object type="OUTPUT_FIELD" id="COUNT_unit" appName="7MNISYRDXXHN07SUPVJMJ26N7" presentation="UNIT"/></Objects></Request>

10: [AADW] checkStep([STEP6])

9: [AADW] [PLAN4] Invoke BWQ2

8: [AADW] executeNext([STEP1])

7: [AADW] checkStep([STEP1])

6: [AADW] [PLAN4] Map CHART1 -> BWQ2.INPUT

5: [AADW] executeNext([STEP8])

4: [AADW] [PLAN4] Reset GRID1, BWQ2

3: [AADW] executeNext([STEPundefined])

2: [AADW] schedulePlan(CHART1_SELECT)

1: [AADW] raiseEvent(CHART1, SELECT)

This log isn't detailed enough for me. Please log a message on this.

What should I do ? I used the debugger option in VC to create this output.

That's as detailed as the debugger gives you so without doing further tracing, I wouldn'e be able to see why this isn't working. This should work as I do that all the time. Try using a chacteristic that isn't time based and test that. There might be problems with date formats, potentially?

Just for completeness. This is a bug, which is fixed in SP9.

Regards, Christian

Ask a Question

Top Q&A Solution Author

User

Count