ETL tools used in Oracle BI that it. With Oracle going round buying up lots of companies they have been creating a huge potential for confusion for the integration community, including their own consultants. We had an Oracle consultant in the other day to tune up the database performance (he…
Category: Uncategorized
Self Configuring Warehouses
One of the reasons people don’t like the DAC is that it takes control over the ETL.One of the reasons I like the DAC so much is the fact that it manages the ETL process with ease! Not only does it run the Informatica tasks in the right order (providing…
Two weeks to go
With only two weeks to go we’re getting very nervous. This has nothing to do with UAT (Which is actually going very well), but all to do with this years skiing holiday! We’re off to La Plagne with the kids over xmas. There’s a webcam service that was showing lots…
Sorted!
An easy and quick tip to sort out the order of time. When the gods invented time they were not considering the Manager running his analytics reports! It’s a simple question that the manager asks; Give me sales figures by month. The answer should look like this January 10February 11March…
Uncategorized
Read more
Navigation
Another popular topic on the message boards of late has been navigation between reports on Dashboards. Most commonly this involves guiding the user to another report/dashboard from a particular value displayed in the results of the initial report, for example, at a financial quarter end you may wish to drill…
All about the Cache
Here a thing that will makeyour reports run faster! Introduction to Cache Decision support queries sometimes require large amounts of database processing. If you reduce the amount of database querying then you can speed up the time to produce reports. In an Analytics system the way to reduce database accesses…
Three sheets to the wind
No, not a description of the weekend’s activities unfortunately, not a drop passed my lips. The sheets to which I refer are CSS or Cascading Style Sheets, PortalBanner.css, PortalContent.css and Views.css. You probably will not be interested to know that the original form of the expression was ‘three sheets in…
Do you feel insecure?
Security. Love it or loathe it? Most of the time the choice is yours, you can choose not to lock your house or car, you can choose not to fly, you can choose to keep your PIN in your phone memory under PIN, what you probably can’t choose is whether…
DAc days
Question. How do you load 80 million records into the Data warehouse?Answer. Slowly! As we are now in version 7.8 of the CRM application there is lots of work around upgrading from previous versions. Normally an upgrade of the data warehouse will provide companies with an opportunity to reassess what…