Emailing reports to non OBI users using IBots

.

Sometimes companies need to distribute their OBI reports via email to their employees. For example the sales department needs to have the weekly sales report on their email inbox every Monday morning so they can start the day analysing the sales without having to download any report in OBI. This can be easily achieved by using IBots, as we can schedule them to send the reports to the users or groups that we want.

But let’s imagine now that as the sales figures are really good and the company decides to email them to organisations outside the company (newspapers, magazines…). In this case as we want to email reports to non OBI users we need to reconfigure the IBots as it is not configured by default to send reports by email to non OBI users.

In this article we are going to see how to send a report by email to users that do not belong to any of the defined OBIEE groups or are users by itself of OBIEE using iBots.

Continue reading this post >

Grand total Conditional Formatting in Pivot tables

.

Sometimes because of the users requirements we need to apply a specific format to our reports, different from the default one. As an example in a table we might have to change the cell colour depending on the value of that column (i.e. Green cell for positive values, red for negatives). In this case we will just apply conditional formatting and we could easily solve it, but this solution does not work in grand totals in pivot tables.

In this article we are going to see how to conditionally format a grand total in a pivot table by changing the XML code of the report.

Continue reading this post >

privacy policy - Copyright © 2000-2010 ClearPeaks

topnav