on 07-22-2007 12:46 PM
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?
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.....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
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?
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.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.