In those rare instances, there is a necessity to utilize the EVALUATE function within OBIEE. Most cases the use is to utilize a database function that is not available, yet, by OBIEE; but, is available within the database reporting from. For example, an analytic function within Oracle. Use of the EVALUATE function will allow to [...]
Archive for April, 2010
Use of Evaluate function for Analytics Function (Oracle)
Posted in Administration Tool on April 27, 2010 | 1 Comment »
Calculating grand total as a column in Table View
Posted in Presentation Services on April 21, 2010 | Leave a Comment »
Calculating grand total column or % of grand total is easy in pivot table view. But how can I create the same in a table view? Well in table view you can create a grand total row with the table view options! But, that is not what we want. We want it so that you [...]
Creating New Web Catalog
Posted in Presentation Services on April 8, 2010 | 3 Comments »
I have been seeing a lot where people take paint or samplesales webcat and either cloning it or modifying it to make a new webcat. This has its issues and problems. For one, you inherit all the users and privileges that are there, especially if you were using and modifying this before you decided that [...]