I ve loaded the data in to the cube from ODS, Say for example, production Unit has values like 7, 8 , 9 etc.. all the data from ODS got loaded in to the cube, Now the problem is ,, the data gets loaded into cube as say 007, 008, 009 like tat in the cube,
During the reporting, when i give production unit as 7 or 8 or 9 ,, it is not able to get that data, but if i give 007 or 008,, im getting the data. Now i want to get the data in reporing when i give 7 or 8 or 9 instead of 007, 008 etc..
What can i do for getting this done,,
Thanks in advance
ill assign points for it