apply alert on chart

[Former Member]

Hi,

We have simple column chart with Revenue and Period.  I have created alert to display Period in Month and Year format (Ex: Feb '13). But I am unable to apply alert which I created. I mean it is always in disable. If I try to display graph in Structure mode to select period and then to apply alert, but it is not displaying in structure mode (simple graph is displaying without any objects structure).

I am able to apply alert if it is a table and period is displaying in expected format. Here i tried to convert table (after alert apply) to chart but chart is displaying with initial data(before alert apply).

So any idea how to select object(Period) within graph to apply alert? like last step in below link: http://blog.davidg.com.au/2011/03/sorting-months-in-webi.html

Version: SP4 patch5

[former_member189638 · Accepted solution]

Create a variable as =FormatDate([Period];"MMM yy")....Use this variable in your chart

[Former Member]

Hi Prem,

Please try what Rakesh has sent, it should work.

In addition, the Alerts functionality in Charts is not supported in BO XI 3.1, see the link below.

http://scn.sap.com/thread/1971806

And Alerts functionality is supported in BI 4.0, see the link below.

http://scn.sap.com/thread/2150980

[Former Member]

Thank you for your reply...

Rakesh,

We are displaying last 6 periods data and period is in the format of 'Period 03 2013' (it is NUMC data type). So can you help on format which you mentioned..I am expecting like below Oct 12, Nov 12, Dec 12, Jan 13, Feb 13, Mar 13.

Hi Hardik,

Yes, I think it will support in BI4 but I am not understanding how to apply it. Can you help me how to display chart in Structure mode and select object?

Thank you again,

[former_member189638]

Are you sure if this is in NUMC format..Becaus eif it is NUMC then it will not allow to use the Text Period for that object.

Are you using BW as backend?? THen I think your Fiscal period will have the Key as 2013003 and Text of that will be Period 03 2013. You must use the Key

[Former Member]

Hi Rakesh,

sorry for delay in my response.

Yes, fiscal period data type is NUMC. I am using BEx query as back end using BICS connection.

Fiscalperiod Key value is displaying - Fisc variant/003.2013 and Text is displaying - Period 03 2013

So can any one help on how to SORT values in chart. I think it will only be solved in chart using alerts.

but I am not able to apply alert on chart...As i mentioned I am expecting below values (with sort)  from the  Text values of Fiscal period

Oct 12, Nov 12, Dec 12, Jan 13, Feb 13, Mar 13

[former_member188911]

The sort is alphanumerical, there is no background logic that allows sorting by month number,

You will need to use the month number not the string

thanks

Simone

[former_member189638]

I believe the Period Text Object will be coming as Char in the WebI. Use the following Formula to do some conversion and formating. Then use this variable in the chart. Hope this helps.

=FormatDate(ToDate((Substr([TextObject];11;4)+Substr([TextObject];8;2));"yyyyMM");"MMM yy")

[Former Member]

Hi Simon,

Thank you for your reply. Could you please explain bit more. how can I get the month number and then apply the sort on Chart?

Also could you please help me on my basic question how to display chart in structure mode and then apply Alert by selecting object 'Period'? last step in below link... is this not possible in BI4?

http://blog.davidg.com.au/2011/03/sorting-months-in-webi.html

Thank you..

[Former Member]

This message was moderated.