Search results for query: *

drlex and blom0344, Thank you so much for your suggestions. However there is nothing much I can do with this table in DB2 as it was vendor designed and we as report developers have very little control on it. So instead I decided to import the table to our datawarehouse environment and go...

drlex, You are right when you said my groupings are data fields A and C1 to C3? and If so, is there a strict relationship between B1, D1 and C1? That is to say, the values in B1 and D1 relate to that in C1? The solution you suggested sounds good, however my dilema is that in the example I just...

Hi All, I have a 10 column table that looks like this: A B1 B2 B3 C1 C2 C3 D1 D2 D3 with data it will be as follows: A B1 B2 B3 C1 C2 C3 D1 D2 D3 ---------------------------------------- X 0 3 7 1000 1100 1200 0 1 3 Y 1 4 6 1000 1030 1100 0 2 2 Z 1 2 5 1000...

Hi All, This is my problem: The weeks in the time dimension is from a column in the IQD. The weeks are directly mapped to the month and the year in the table itself example: 2002 Nov 10/28/2001 2002 Nov 11/04/2001 2002 Nov 11/11/2001 2002 Nov 11/18/2001 2002 Nov 12/02/2001 My dilema is when I...

Hi John, I rechecked the precision, and output scale. This cube has been there for last 1 year, never had this problem before. Not sure why its happening now. I even reinserted the datasource just to be sure... Thanks Sil

Hi All, I have a wierd situation. May be one of you has a solution for it!! I am generating a cube using IQD's. The cube built is going fine. Its picking up every data, except for one market. I counter checked the table and the query to make sure the data is there. But for some wierd reason...