BVI/BVHEI Report users

Consider the following points before opening a Ticket:

  • Do not create X or Z query in the production system.
  • If the requirement drives you to change the standard row/column (Ex, changing P&L row structure to column) structure of the basic query design, please check with the development team.
  • Drilling down on characteristics can create extra runtime overhead on the system. Don’t create a ticket unless each drill down takes more than 5-10 minutes.
  • If the runtime on the vanilla query consistently exceeds 5-10 minutes with a reasonable selection criteria, then only create the ticket
  • Some of the selection screen has 4 – 8 filter conditions for entering hierarchies (like CCenter , Profit Center, DestGeo, Media Product, Account and so on). Please do not enter more than 4 of the above hierarchies in the selection screen. Always, enter values for nodes. Do not just enter Top nodes
  • Please run the appropriate query. If you need to see only Group Currency, then please run the sheet in the report which has Group Currency, instead of running the sheet which has all currencies and then filtering on Group Currency

Other BW Reporting Tips & Tricks

  • Variants are currency worksheet dependent (e.g. local, transaction, all). So if it looks like your variant has disappeared, check the worksheet.
  • When logging tickets, it would be helpful to the technical team who receives your issue if you include:
  1. A saved variant name in addition to the screenshots so they can replicate your exact selection criteria
  1. An attached excel file
  1. Please note that the Help Desk does not support any issues dealing with topsheets and/or alternate hierarchies. For questions/issues about hierarchies issues to Burbank Studio Site Sustainment
  • Layout Tool – can be used to display test elements including all variables and/or filter elements
  1. Layout => Display Text Elements => All/General
  • If you have multiple input values, you can save a list in Notepad and then copy & paste the selection into your Selection Criteria window
  • CNTL-C = copy
  • CNTL-V = paste
  • CNTL-Y = highlight multiple items
  • Use the trash can to delete all
  • In BW, you can use the following functionality to translate currencies.
  • Right click to open the window below.
  • Select Target currency, and then type in the 3 digit code for SEK, EUR, USD, DKK, JPY, etc.

The group currency figures in the FROZEN version will be translated at the forecast rate, where as the PCC figures are at the Budget rates. If you are comparing frozen versions to PCC, you should do so only at transaction currency, do not use group or local currency.