SAP based universe takes 45-60 minutes to build and refresh
One of my SAP based Universe takes 45-60 minutes to create and refresh. The universe is based on a BEx query which uses Sales data.
Is this normal behaviour? Does the cube size and number of records in the cube on which the BEx query is based has to do something with it? If so, what is the standard for BEx queries on large cubes? Is thequery split into multiple queries and if yes, how does the information tie back together?