Flexible Reporting Options

[#1]

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.

[Former Member]

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?

[Former Member]

Hi,

It is possible as you said. You can ask the user for previous day, week , month and using customer exit you can display relevant results.

One more option to do without CMOD is specifying variable ranges on 0CALDAY.

Message was edited by: AVR - IGA

[Former Member]

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?

[Former Member]

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.