November 27, 2001 at 1:18 am
Hi, all. I'm developing a data warehousing system using Analysis Service. Everyday I transfer data from OLTP system to Analysis Service. But I never able to build a fact table for my data. There is always something's wrong with my data. What's wrong ????
November 27, 2001 at 3:07 am
I have a little experience of this, but will need some more info: what error messages are being returned? Are the dimension tables being populated ok? Is the schema changing? etc.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
November 28, 2001 at 12:38 pm
Hi Hendra,
As Paul said, to specifically respond to your problem, we do need more information. However, there are general books on the subject if you are looking for a high level approach. A classic is Ralph Kimball's The Data Warehouse Toolkit : Practical Techniques for Building Dimensional Data Warehouses. I'm not pushing Amazon.com (never bought anything from there, myself), but this page should give you an idea about the book itself because it does have some sample pages linked:
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
November 28, 2001 at 12:45 pm
December 4, 2001 at 4:35 pm
A common problem loading fact tables into an OLAP Services cube is failure to rebuild dimensions prior to the data load. There are occassions where the OLAP dimensions do not get rebuilt properly, causing the facts and the dimensions to be out of synch in the cubes. Be sure to process your dimensions before processing the cubes and this might help resolve some of your problems. Also, be sure you are imposing referential integrity on your star schema to avoid the same problem in the relational source tables.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply