Adding Parameter Drop-Downs To OracleBI Dashboards

Thursday, August 31st, 2006 by Mark Rittman

In this next series of postings, I’m going to go through some of the more advanced features of OracleBI Answers and OracleBI Interactive Dashboards, and look at:

Adding a control to a dashboard page that passes a parameter value to the reports that are embedded within it;
Creating a view selector, so that […]

Three Days in the Netherlands

Thursday, August 31st, 2006 by Mark Rittman

Well that’s the first of the BI Seminars over and done with now, and I was pleasantly surprised that, firstly we had around thirty attendees, and secondly, it more or less went off without a hitch.
I must admit I was expecting about a maximum of ten attendees, so thirty was pretty good and about the […]

Three Days in the Netherlands

Thursday, August 31st, 2006 by Mark Rittman

Well that’s the first of the BI Seminars over and done with now, and I was
pleasantly surprised that, firstly we had around thirty attendees, and secondly,
it more or less went off without a hitch.
I must admit I was expecting about a maximum of ten attendees, so thirty was
pretty good and about the maximum you could […]

Adding Parameter Drop-Downs To OracleBI Dashboards

Thursday, August 31st, 2006 by Mark Rittman

In this next series of postings, I’m going to go through some of the more
advanced features of OracleBI Answers and OracleBI Interactive Dashboards, and
look at:

Adding a control to a dashboard page that passes a parameter value to the
reports that are embedded within it;
Creating a view selector, so that users can switch […]

Reporting Against Multiple Datasources in BI Suite Enterprise Edition

Saturday, August 26th, 2006 by Mark Rittman

Whilst in some ways it’s good that you can bring data from different data sources into Oracle BI Suite Enterprise Edition, this is only of limited value if individual fact tables and dimensions are only made up of data from a single data source. Your sales fact table might take data from a relational Oracle […]

Reporting Against Multiple Datasources in BI Suite Enterprise Edition

Saturday, August 26th, 2006 by Mark Rittman

Whilst in some ways it’s good that you can bring data from different data
sources into Oracle BI Suite Enterprise Edition, this is only of limited value
if individual fact tables and dimensions are only made up of data from a single
data source. Your sales fact table might take data from a relational Oracle
table, whilst your budgets […]

Finally Finished

Wednesday, August 23rd, 2006 by Mark Rittman

Well, that’s finally finished now. After about two months of effort, mostly in the evenings and on train journeys to and from London, I’ve finally finished the course material for the seminar series I’m starting next week.

The normal routine I go through when doing a new presentation is to first put together the slides, to […]

Finally Finished

Wednesday, August 23rd, 2006 by Mark Rittman

Well, that’s finally finished now. After about two months of
effort, mostly
in the evenings and on train journeys to and from London, I’ve finally
finished
the course material for the seminar
series I’m starting next week.

The normal routine I go through when doing a new presentation
is to first put
together the slides, to give the talk some structure and pull […]

YTD Alternatives part 2

Thursday, August 17th, 2006 by Peter Scott

Yesterday, I wrote about the use of a table function as an alternative to a date transformation table in the calculation of YTD. Mischievously, I used filter conditions to restrict my selection to a single product and store over an April until now window. The results I captured show little difference between the three techniques […]

Year-to-date alternatives

Wednesday, August 16th, 2006 by Peter Scott

David Aldridge challenged me to write about functions that return lists of dates. So here goes
In blogs past I wrote about the joys of calculating year-to-date, YTD, on sparse data sets. To my mind sparsity is a good reason to not include ytd values in slightly aggregated summaries.
But that still leaves us a few methods […]