When selecting filter values for time characteristics, some users noticed that they can’t find the dates they want, although, these dates exist in the infoProviders.
Apparently, there’s a default date range setting for time characteristics, e.g.0calday, 0calmonth, 0calweek. To change, go to t-code SPRO -> F5. Path may vary depending on the system.
SAP Netweaver –> Business [...]
If you have a query with all the characteristics and key figures from an InfoProvider, users will be very happy to use it instead of creating their new queries. The trick is the have all major variables in the varaible screen and train the users to use “Save View” feature of Bex web.
BW also provides similar feature through RSRT, except [...]
To be able to monitor the BO connection with BW server easily, I decided to use system users for creating universe.
This user doesn’t need a lot of accesses.
First, make sure profile is correctly generated in pfcg; turn on the Authorization trace; watch st22 for authorization related dumps.
Authorization object: S_RFC
RFC_TYPE FUGR
RFC_NAME SUSO, SUNI, RSCR, SH3A, RFC1, RZX0, RZX2, [...]
My company recently purchased Xcelsius. So, I got a chance to play with SAP Business Objects, including Universe, Webi, Live Office, Xcelsius, Polestar, mobile application, Crystal Report, etc, etc.
I need some time to get to know the functionality of these new tools. When I am able to create some fancy schmancy Xcelsius dashboard in 5 [...]
BW3.5 table RSRVARIANT doesn’t exist. There’s no way to transport BEx query variants.
In BI7.0, variants are transported by transporting table RSRVARIANT.
These BW settings are on the Business Explorer tab of the Characteristic infoObject.
If the users experiencing slowness when getting master data value in their reports or when changing the queries, you should consider adjusting the setting.
If the fields are grey, check if there’s a reference characteristic. Then change the setting of the reference characteristic.
Only Values [...]
This program allows you to be really lazy if you want to have some sample records in a InfoCube. No need to use flat files, edit the value in a ALV-Grid or let the system generates random values for you. It works only on InfoCube, not ODS. Works for BW3.5 and BI7.0
The records are added to the cube [...]
Less than a year ago, a pretty smart developer told a group of us, self-absorbed Unix, database admin, java/web developers, “I am learning Excel, it is very powerful, “. We had a good laugh about him. Ironically, I got his point now. A well-designed Excel dashboard can give BW a huge face lift in front of the executives and [...]
I am excited with my interesting discovery.
When
1. the key figure A in the structure S is a calculated key figure,
2. A is calculated from two or more restricted key figure (C, & D),
3. Characteristic B is used to restricted C & D.
4. Characteristic B is also used to restricted in a selection of structure S
The number gets doubled in the [...]
In Bex Analyzer, first, you don’t see the technical name of a workbook, you also can’t delete them.
In our system, several workbooks are created from a common workbook template, and save in a folder of an user workbook role.
To save the new workbook, the old workbook need to be deleted from the Role. Then, those unused workbooks should be deleted from [...]