cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic changes in the report

Former Member
0 Kudos
50

I generated one report in BI 7.0 using the BEx Analyser. But what the user want is to simulate the report in according to the market changes. For example: Suppose fields for the ingredients of a product and the % of amount used to get the profit is there in the report. He wants to try for the various possibilities that he can do to get better profit from his products mentioned in the BEx report. So what he wants is ‘whatever changes he do in the report should reflect the other fields in the report for planning his future composition. How can this be done in the report? Is it possible by using macros? How to use Macros in this case? Can someone please explain this in detail?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Mathew,

In this case you can go for a workbook with a macro. Just hide the output sheet and refer the values to a new sheet. In the new sheet write a macro. Also provide a button to refresh after entering the data by the user. Upon refresh(by pressing the button provided in the sheet) the values will reflect in the expected way.....

Former Member
0 Kudos

Thanks Phillips.

Can you please explain the same in detail as I am new to the macros.

Answers (1)

Answers (1)

Former Member
0 Kudos

are you looking for 'Profit should reflect based on Ingredient configuration'?

how are you calculating your profit right now? Let us know about cube model.

Nagesh Ganisetti.

  • Assign points if it helps.

Former Member
0 Kudos

Thats a similar example only. what the real scenario is.. In the report generated it costs altogether 2000 USD. And what he seen from the market is that there are certain price changes for the raw materials he used for the product. So what he want to do is to change the price of that raw materials in the report, and as a result all the fileds this price are related should reflect the change. So that he can plan accordingly... How to proceed to get the result? please explain in detail(step by step).

Former Member
0 Kudos

Can anyone please reply for the above question? Its Urgent

I hope this can be solved using macros. After refreshing the query the corresponding formulas need to be generated to an excel sheet and use macro codes to get the result as required.. But as I dont know anything on Macros..can anyone reply in detail, whether it is possible by using macros if possible how? Can someone send me a sample code in macro for finding sum of two keyfigures in the report?

Former Member
0 Kudos

I think you are asking for user to be able to input a "what if %", so the report will display calculation based on user input? right?

If so, you want to create a <u>formula variable</u>, so user gets prompted for %, then that amount will get calculated based on user entry.

Former Member
0 Kudos

I generated one report using BEx Analyser. In that report price of individual raw materials are there and the total cost for the production of a commodity from that raw materials. After the report generation my client understood that the price of certain raw materials varied. So he wants to change the price of the raw materials manually and get the total cost after the change. This is the requirement.

What I think is that the formulas used in the report can be generated to another excel sheet and using macros i can do the calculation and can show the result in the new excel sheet. I dont know whether this idea will work or not as I am unaware of how to generate the formulas to another excel sheet and I am unaware of the macro code. So can anyone help me to solve this issue by explaining in detail and can someone send me some macro codes for example that can give an idea of summation of filed values.