How do I design a Workbook which gets values dynamically.

[Former Member]

Dear Experts,

I have a requirement to design a workbook " For a particular product It should have to display revenues monthly wise in Line chart".

So I have gone to Bex Analyzer (in the variable screen I have provided "product" and for period of 6 Months( 01/2010 to 06/2010) ) and while designing Line chart have manualy provided the values of 6 Months and Key Figures. It shows me Line chart for 6 Months.

But my client requirement is to show the values of any period which he has selected.

How do I fullfill that requirement and I am doing this in 3.x version.

Please provide me the solution and do the needful.

Thanks,

Swathi.

[former_member202718]

Hi Swathi,

In the Ananylzer,run the Query and save it as Workbook

Now Insert the Line type chart in the Work book,it will dynamically pick the data from the report.

If u change the values in the input ,it will accordingly update the Chart.

In case u put in a Diff Sheet,then u need to assign it manually !!

Rgds

SVU123

[Former Member]

Thanks for your reply .

I have done like this.

1.Opened the query using Analyzer with open selections.

2.Saved it as new work book.

3.Opened that work book and I have gone for Line chart

In the Line chart I have provided column details in the data range tab page means Key Figure(selected it in Navigation ) and Call month/year from the Navigation.

Now it is not fetching the data.

what i am doing is correct or not??

Thanks ,

Swathi.

[former_member202718]

Hi Swathi,

Yes , i just tried out the same thing in Bex 3.5 and is working perfectly fine...the only diff is

I am dragging the Line chart in the same sheet as Report and it is getting assigned by Default ,i.e i am not assiging the

data range and the next time when i change the Variable the data and the in turn the Line Chart is changing Dynamically ...

In case it is not assigning Dynamically then u can assign it manaullly but u have assign it for Extra Columns or Rows ...

So that if the user sees it from 04-08 months only 5 columns are required and if he sees for 04-10 the 7 columns are required.

So see to it that when choosing the Range u choose some columns or Rows Extra .....

If the user chooses till 04-12 then he shud be able to view data for that also and if it is 04-06 that also shud be okay..

Just give the extra range than required.....make it flexible.....

U can search more of the Excel fuinctions in the Excel Help Forums....

Rgds

SVU123

Edited by: svu123 on Sep 16, 2010 9:37 AM