July 9, 2014 at 2:14 pm
Hi,
recently our orgnization decided to go with MSBI. We started working on the SSAS Tabular model.
I am trying to import data from Oracle and it has pk_id which is a number in source. But when I imported that to SSAS Tabular its coming as expoential format and which is causing duplicates. I can't make joins due to that.
All PK IDs taking in exponetial format. I tried coverting the data type after imported the table into SSAS Tabular.
My question is that is there any way that I avoid this issue when I am importing?
Thank You
July 10, 2014 at 9:13 am
Your data is likely displayed in scientific notification, just change the data format properties to General
July 10, 2014 at 10:57 am
Thanks for the reply.
I changed the datatype to Whole number and data format to whole Number.
It processed again and coverted the column to Number format but now we are getting same number for two or more diffrent records which is causing duplicates error when we establish join between fact and dim.
when I went to Toad and check for any duplicates in Dim table, I dont see any duplicates.
Thank You
July 10, 2014 at 12:54 pm
What SQL statement are you executing?
You can get the SQL statement by going to your dim table and select Table/Properties, if data is shown switch to: Query editor.
July 10, 2014 at 2:21 pm
I am not directly importing table. I am uisng a SQL like
Select * from Dimtable
where pk_id (select pk_id from factable where period between 20130101 and 20130131)
I am not importing as a table since I want the for particual period.
My fact table will be
select * from factable where period between 20130101 and 20130131
once imported, I went to pk_id columns and went to properties, I set up datatype and data format as whole numbers.
Interesting part is some times when I do like above, its coverting to unique numbers. Some times its not coverting as unique numbers.
I have no idea on how to fix it up.
Thank You
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply