I have a problem in my app.... i have several tables linked to each other and an independent calender (means calender not linked to tables in d model)...
now in chart i m using diz independent calender as dimension ....all working fine (Data values are correct)
now the problem is wen i open tat app it takes alot to load i mean d chart occurs as green scrollbar (Loading) for few minutes and den the value occurs.... i dont want tat scroll bar cuming.... Can anybdy help???
How many records you have in your fact table, millions? Then its normal that it takes seconds but not few minutes!
It is better and more efficient to do calculations/ conversion at the time of data loads in the model itself. This will improve the performance of charts refresh.
Example:
You have got 3 million records in your fact table. The fact table contains PRICE, QTY. Its better to add additional column in the fact table called TOTAL := PRICE * QTY.
This will reduce computation effort on the charts when you display TOTAL of a record.
Its good idea that you check the keys between fact table and dimenions, are they the correct keys? You need to combine additional columns in the key to uniquely link the dimenions to the fact table rows?
