Why have I not written a blog for ages ?Does Siebel Analytics work on IE7 ?Is there a version 8 of Analytics, if so what is it called ?What is the difference between Siebel Analytics and Oracle BIEE ?Where are all the best Analytics consultants ?How do I find good…
Just Another Date
Well there’s lucky, Justin had dates in mind and so did I! I have been fortunate toenough to have easy access to W_DAY_D and a plethora of pre-calculated YTD andaccount period end figures so all plain sailing.As we are working on Analytics for a Siebel Financial Services implementation wehave a…
Date Formats in the Analytics Application
Justin Townsend, a member of the Majendi team has some useful advice… Dates are often a point of consternation – for users and developers alike – in theanalytics application, but there are many reasons why they are used. Dates andtheir derivations are often drawn from the warehouse table W_DAY_D, but…
For Instance
Bit of a techie one today, a short introduction to instanceconfig.xml. Instanceconfig.xml (we’ll call it IC) is a configuration file for the Analytics web. It is a replacement for using the registry. You could use the registry but there’s little point, and you probably won’t have access rights anyway. The…
And then there were three…
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…
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…
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…