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?