|
Search
-
This week I attended and presented at my first UK Oracle User Group, Special Interest Group (SIG) for Essbase and Planning. Attending the UK OUG was definitely beneficial and great to find out what other people are doing with the products. I would thoroughly recommend this to anyone who has an interest in Essbase and Planning to attend these ...
-
I haven’t blogged for a while, mostly because I have been busy. Today I am on a train to London , so I thought what better thing could I do to fill the time than to blog about something I have been meaning to blog about for a while: Modelling Slowly changing many-to-many relationships in a Data Warehouse.
This is something that, on paper, seems ...
-
-
Shaun, for iTunes you could quite easily write something that looks at your iTunes library and passes out cxml like below, try it out:
<?xml version="1.0"?>
<Collection Name="My Music Collection" SchemaVersion="1.0"
xmlns="schemas.microsoft.com/.../2009" ...
-
Recently I have been tearing my hair out with SmartView as whenever I perform a large query against my Essbase cube I receive a timeout that suggests I should up the NetRetryCount.
“Fine” I thought, so I updated the Essbase.cfg file with the following (just to be sure):
NETDELAY 8000
NETRETRYCOUNT 8000
and restarted Essbase and re-tried my ...
-
Many businesses want to see measures across multiple currencies, for example: sales for all countries or customer balances for all account currency types. Typically when dealing with multiple currencies a ‘base’ currency to report on is chosen to make life easier (you can’t simply add Euro sale values to Sterling sale values and get the correct ...
-
When building a dimensional modelling solution, somewhere along the line you will almost certainly have at least one multi level hierarchy within one or more dimensions. A good example of this is a Product hierarchy, which might go:
Department->Sub Department->Type->Product
Typically for each level member you will have an ID (be it ...
-
In a Data Warehouse, you’ll typically get at least one slowly changing hierarchy. You’ll probably also have other
slowly changing attributes on the same dimension that are not in the hierarchy, causing many changes.
Setting up this scenario in SSAS 2005 is easy, but it is also easy to do it wrong! Therefore I thought it would be
useful to blog ...
-
Today I installed the Oracle Essbase 11 Excel add-in. All worked well and I could connect to Essbase fine.
When another user logged on to my machine and attempted to use it, the user could not connect to Essbase using the Excel add-in (nothing would seem to happen) and when trying to initialise the API would receive error #1030000.
It seems ...
-
The Inferred method is generally a great way to deal with early arriving facts. I have added an additional way on my blog series and you can read it here: community.altiusconsulting.com/.../kimball-microsoft-data-warehouse-what-the-don-t-tell-you-part-4-dealing-with-failed-lookups-amp-early-arriving-facts-alternative-approach.aspx
|
|
|