June 30, 2011 at 3:00 pm
I have a situation in DWH where one of the dimension is not loading properly which is product dimension.
The product dimension data comes from four oltp databases.so data which is coming
from one of the oltp databases is creating a new record instead of doing a update for the already existing record.
So for a same product id there are duplicates.
the dimension is related to 6 different fact tables.
Now i need the remove the duplicated dimension values in the dimension table
and update the correct productid in the facttable
July 15, 2011 at 1:05 am
You'll need to put some ETL into place that cleans up the data before you load the cube. SSAS expects clean data, so you need to solve this issue before SSAS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 22, 2011 at 12:07 am
Koen is right. You should create a star schema (ideally) for SSAS to nicely consume tables.
Though nothing (apart from following best practices) stops you from using SQL (Named View) in Data Source View (DSV) in SSAS solution.
You can easily create a script, which would group the table with duplicates by the column, which you think should be the key, ProductID for example.
Though I personally would not try to put much logic of such type in DSV.
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply