ETL process to create new cube that will hold counts for dimension

      ETL process to create new cube that will hold counts for dimension

      Hello All,

      Our client's Jedox report has PALO.DATA.CNT functions in several cells and we thought it's one of the causes of slow report's performance. We received some suggestions make these 'part of the ETL process, create a new cube that will hold the counts for the dimension selected, so instead of Jedox calculation those numbers, we have them ready to go in a separate cube.'

      Does anybody here encountered this requirements? Can I ask for a simple example of Jedox Integrator project with the above process?

      thank you in advance and more power!

      Best regards,

      blurred