Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query Performance

Hi,

Had a question...for SEM-BPS, transactional cube is used for planning. All the queries are based on this transactional cube only. Some queries run really slow because of the complex structures involved in rows section (that is strcutures with selections restricted to hierarchy nodes or range of hierarchy nodes). Will it be a good idea to push all the data to a basic cube and create complex reports on it or is there another alternative?

Usually in an SEM environment, do they just create queries on transactional cubes only? What is the norm?

Thanks!

Former Member
Not what you were looking for? View more on this topic or Ask a question