Recent content by PAULSGS

You could create 6 or 7 variables in your report based upon a single retrieved column and use these variables in your report

I have used decode (Oracle) to achieve this

This problem occurs frequently, but not all the time, our WEBI environmnet is 6.5 on W2k SP4 against DB2 UDB 8 When a particular user account "prod1" is used to demonstrate the creation of **personal documents** the name that the user chooses for the report is often (but not always) replaced by...

WEBI 6.5: Is there any way of improving the display of twin column Lov's? From this LONDON||LON NEW YORK||NY to look more like this LONDON |LON NEW YORK |NY

We have a query & reporting environment based upon a star schema accessed by the Business Objects WebIntelligence Reporting tool. I have a fact table of journies. The records have columns for departure and arrival points both as numerical ids and as 3 letter abbreviations. Dimension tables...

I have a fact table of journies. The records have columns for departure and arrival points both as numerical ids and as 3 letter abbreviations. Dimension tables hang off of these two columns and users can retrieve details of journies "TO" a destination or "FROM" a start point. Single column...

We have used profile.txt to set a server wide default universe for new WEBI 6.5 users. However this only worked while we had a single Business Objects application. Now a second one is coming on stream requiring a different universe. Is there anyway of setting a default universe for an...

Have you thought about resolving this problem at a database level and writing the results to a temporary table or using a stored procedure?

This is just a thought. If you are prepared to automate a rotation of the BO Chart using another tool, why don't you try a more radical approach and get the data into Excel and use the horizontal bar charts facility available in that product? The forums are full of techniques for getting BO...

A conformed dimension is one that can be applied to more than one datamart. If you imagine datamarts as building blocks of a datawarehouse then conformed dimensions (i.e. those that "conform" to naming, definition and other corporate standards) will enable you to consolidate the data...

Do you always have data in each of the 3 fields in the first table? Or do you only have data in 1 of the 3 fields? If this later is the case, could you use CASE or DECODE or NVL (in Oracle, or the equivalents in other DBs) to reduce the potential 3 fields down to one definitive field? If so...

This is the sort of SQL that will work out the value you want SELECT MAX(AVERAGE) FROM ( SELECT AVERAGE FROM MONTH WHERE MONTH = (SELECT MAX(MONTH) FROM MONTH) UNION SELECT MAX(QUARTERTRAVERAGE) FROM YEAR WHERE QUARTER = (SELECT MAX(QUARTER) FROM YEAR) UNION SELECT...

A colleague and I have wrestled for a while now with trying to enhance a prompt embedded within an Oracle Analytical Function. We would like to offer our uses the ability to compute Moving Averages over 3, 6 or 12 month period. As Oracle considers the current month part of the set, our prompts...

You could define objects with hints as their definition, they will not pass the "parse" check but they run fine when combined with other objects. Of course you will need to pick the hint object before any others so that it follows the select

Would it be possible for your SP to be modified to return a message to indicate no results found? This way at least one row is always returned to BO and it can distribute the report with the message returned from the SP