topic Re: Prevent users from combining specific dimensions in App Development

Prevent users from combining specific dimensions

Fabiano_Martino_Intelco — Mon, 29 Apr 2024 15:10:57 GMT

Hi,

we have users with the full level authorization, so they can create their own charts.

In our data model we have two fact tables (say purchases and sales) and sometimes the users will create charts picking dimensions and measures from both tables.

This creates a spike in the server RAM, because the specific combination of dimensions and measures creates a cross join.

Can we use a preemptive control to avoid this situation? It would be nice to put a memory limit on the specific charts or, even better, to prohibit specific dimensions and measures combinations.

Thanks

Fabiano

Re: Prevent users from combining specific dimensions

rwunderlich — Tue, 30 Apr 2024 17:35:49 GMT

You can detect these multi-table combinations using QSDA Pro after the fact. But I don't have an idea as to how you can prevent them from getting created in the first place.

-Rob

Re: Prevent users from combining specific dimensions

Fabiano_Martino_Intelco — Thu, 02 May 2024 10:01:50 GMT

Hi @rwunderlich

QSDA Pro is indeed a useful tool.

In my specific scenario I would like to have a check before the situation arises.

The function GetObjectDimension() seems interesting, but it requires the index of the specific dimension to be tested.

Since I won't know beforehand how many dimensions the user will select I have a problem here.

It would be nice to have a function returning the complete list of dimension for a table, maybe with a custom separator.

Thanks

Re: Prevent users from combining specific dimensions

marcus_sommer — Thu, 02 May 2024 10:31:29 GMT

I suggest not to cure the effects else the cause - which means to adjust the data-model. Officially recommended is a star-scheme with a single fact-table and n surrounding dimension-tables.