topic Re: Always create hypercube on full data set (ignore filters) in Integration, Extension & APIs

Always create hypercube on full data set (ignore filters)

tversweyveld — Tue, 08 May 2018 13:28:10 GMT

Hi,

I'm building a mashup that uses data from multiple hypercubes.

A few of those hypercubes should only be created once, when the page loads. The data is used to create menu's that should remain static after initial creation.

I managed to do this by calling the function like this, so that it is ran only once:

app.createCube({ ... }).then(function(reply){ build the menu })

When the page is refreshed all filters are cleared before the cube is recreated, but sometimes the cube only returns the filtered values.

My question: is there a way to make sure that all filters are ignored when creating the cube?

Thanks!

Re: Always create hypercube on full data set (ignore filters)

ErikWetterberg — Tue, 08 May 2018 13:32:24 GMT

Hi,

You could use set analysis in you hypercubes. Or make sure the menu data is on a separate data island, not connected to the fields available in filters.

Erik Wetterberg

Re: Always create hypercube on full data set (ignore filters)

tversweyveld — Tue, 08 May 2018 13:44:30 GMT

Hi,

Thanks for that! Do you know how I can put a hypercube on a separate data island?

Re: Always create hypercube on full data set (ignore filters)

tversweyveld — Tue, 08 May 2018 13:46:01 GMT

Oh nevermind, I get what you mean. But the menu data has to remain connected to the other dimensions.

I will try with set analysis