on 04-27-2006 3:12 PM
I have created a Line Efficiency report using PP data in BW. This report has several audiences.
Each week executives would like to view efficency trends at a plant level by week say over a 6 week timeframe.
Each day plant controllers would like to view efficiency data trends at a workcenter level for their plant by day for the current week.
Each day line supervisors would like to view efficency data at a material level for their specific line (workcenter) for the previous production day.
I can easily set up a query/web template which can deliver this information but significant user interaction is required to get to 2 of the 3 layouts. What, if any, options do I have to allow this information to be presented in mulitple layouts? Additionally, I would like to broadcast these various outputs so any solutions hints on that would be appreciated as well.
Hi John,
Did you manage to get any resolution for your question? I'm having the same problem and would be interested to find out more.
Thanks,
Madeline
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is there any way to present a variable to the users giving them choices of date ranges and then populate those ranges in a customer exit via logic in CMOD
For example, I would like a dropdown list that contains values like: Previous Day, Previous Week, Previous 6 Weeks etc.
Based on the value input here I will determine the range that should be populated in 0CALDAY.
Is this possible?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I do not want to just give a range variable for 0CALDAY because I want to be able to schedule this report for broadcasting.
You say it is possible to ask the user for previous day, week , month and using customer exit you can display relevant results. How is this possible? I am struggling with how to create a variable like this. Can you be more specific?
Hi,
You can create a text variable and based on that you can manipulate in the exit code. For example if I take a text variable the user can enter 'Q' for Quarter or 'Y' for year or 'W' for week result. by reading this in the exit we can populate respective result in the columns which should include other variables. Think for the logic, you can get that.
I understand the concept of query views to get different looks at the data.
However, if one group of people is looking at the most recent 6 weeks of data, another group at the last week of data, and a third group at yesterday's data, how can I setup the broadcaster to execute for different & changing periods of time?
Is this possible or should I be creating several queries?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jonathan
Try precalculation of web templates . Now eash group want to data with different timeframe (6 weeks , last week and yesterday's data ) use Customer exit variable if these patterns are fixed for the role. Like a plant supervisor want to visit last 6 weeks data then you define that logic in CMOD for a variable.
Then use download scheduler -> with this the users can download their respective views at predefined frequency.
Hope this will help.
Regards
Pradip
(Friends: Don't forget to assign points)
Hi Jonathan,
You can try to use Views on BEx. The single query can be saved with different layouts like different Views.
For the broadcast you can use Reporting Agent, scheduling Web Templates based on the Views defined in BEx.
Ciao.
Riccardo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.