Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Cubes in qliksense

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

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

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

4 Replies
petter
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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
Not applicable
Author

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
Specialist III
Specialist III

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.