Forum Discussion

HotChilli's avatar
HotChilli
Community Champion
4 years ago

Maybe.  Examine your model to see if the Fact table(s) have the desired granularity , for example, if you never analyse the data at a daily level, summarise it at weekly/monthly level to reduce the number of rows.

Also, use performance analyser on the View menu to see what's taking up time and define 'forever'. Write these things down to act as a baseline.

Is the model a star schema? Are you using appropriate data types etc.? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    thanks for the response HotChilli  the fact tables do have the corrent grainularity, it takes about 2 min. for the table to load & using the correct data types. Yep star schema