Solved: Cubes in qliksense - Qlik Community

Anonymous · ‎2017-11-19

Hi,

Is there any way to acheive cube functionalities in Qliksense. We wanted to migrate cognos cubes into qlik and generate visualizations out of it. Goal is to provide same kind of data slicing/dicing to customers as cubes provides.

Thanks

VM

petter · ‎2017-11-20

Since Qlik Sense is completely indexed - both text and numeric - all fields no matter what - the necessity for cubes are not there actually. Cubes are a way of explaining and creating a limited number of indexes for OLAP systems that orginally worked towards disk.

Due to the in-memory fully index nature of the Qlik Associative Model you can make any combination of fields into. So you think of it as a dynamic cube creation without any limits.

Slicing and dicing in Qlik are achieved directly with the built-in visual objects as (almost?) any selection will do a slice/dice and recalculate on the fly.

View solution in original post

petter · ‎2017-11-20

Since Qlik Sense is completely indexed - both text and numeric - all fields no matter what - the necessity for cubes are not there actually. Cubes are a way of explaining and creating a limited number of indexes for OLAP systems that orginally worked towards disk.

Due to the in-memory fully index nature of the Qlik Associative Model you can make any combination of fields into. So you think of it as a dynamic cube creation without any limits.

Slicing and dicing in Qlik are achieved directly with the built-in visual objects as (almost?) any selection will do a slice/dice and recalculate on the fly.

petter · ‎2017-11-20

If you are satisfied with the answer please mark it "Answered" and/or "Helpful"... If you need some further explanations related to the question feel free to elaborate.

Anonymous · ‎2017-11-20

Thank you for the response.

There are many dimensional levels created in the cube each having different levels. As the cube pre-calculates each measure at all levels and store that aggregated information in memory for quick results(eliminating calculations during the run time). As the qlik do aggregations during the runtime, will it not cause any performance degradation ?

Is there any way to auto calculate at each level and store in a memory for Quick insights ? do we have any option to schedule and refresh data in regular intervals in such way for all dimensions and measures are calculated?

JustinDallas · ‎2017-11-20

With Qlik, you really don't have to do that pre-aggregating stuff. Have you tried working with your data set without pre-aggregating? Before you optimize, let's make sure there is a problem first that isn't already fixable with a standard implementation.