Multiple transaction date

[renjithpl]

Hi All,

I have a table with 10 million records, but i have three diff dates (Created_Date, Closed_Date, Win_Date).

I created a Master calendar where I have "Date_Field".  (concatenation of all the three dates)

I want to show the transaction happened for all three dates in different charts.

I have split the 10 million table into three different table with Created_Date, Closed_Date and Win_Date.

My application is heavy now. with 30 million records.

Is there another approach where i can get this without splitting.

THanks

Renjith

[Anil_Babu_Samineni]

How is your split code? I am thinking about creating FLAG to use different scenario. Have you done the same?

Load Date1 as DateField, 'Date1' as Flag, .....;

Concatenate

Load Date2 as DateField, 'Date2' as Flag, .....;

Concatenate

Load Date3 as DateField, 'Date3' as Flag, .....;

In UI, you can use any one of Flag as per business need like

Sum({<Flag = {'Date3'}>} Measure) // This returns only sums the Measure where Date3 field has data points..

[renjithpl]

I have tried this, but will you connect from this bridge table to the Transaction table with Three dates.

Which Key ? I have to have a combination key in my transaction table too.