Skip to Content
avatar image
Former Member

Flexible Reporting Options

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Apr 27, 2006 at 05:40 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Pradip

      Can you expand upon your suggestion? Are you saying that we should have a different role for each of the jobs and based on the role assignment that would change the default value of a variable via CMOD?

  • avatar image
    Former Member
    Apr 27, 2006 at 03:11 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 02, 2006 at 02:52 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

  • avatar image
    Former Member
    Aug 31, 2006 at 01:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded