How to compute the QueriesResultLimit?

[HuifangYeo]

I get the below error message during visualization:

How do we compute the limit size that should be set? I don't quite get the below:
Please increase the IQueriesResultLimit context value accordingly.[points size before contribution = 1000000, contribution size = 1, max limit = 1000000]

Also, instead of applying the context for the whole cube (https://docs.atoti.io/latest/lib/atoti/atoti.cube.html#atoti.Cube.shared_context), can we apply it to the specific visualization?

[bloussou]

Hello,
For cube.query() and session.query_mdx() you have a context parameter.

I'm looking for a way to have it in notebooks visualizations

[tibdex]

#195 (comment) mentions how to add context values to a widget from JupyterLab. From the expected shape of the state you can enable the ADVANCED_APP_EXTENSION and then use the context value editor in the app to change to context values of a widget and see how it impacts its state when saving it.

[HuifangYeo]

The problem can indeed be overcome by configuring shared_context but this is at the cube level.

# cube.shared_context["queriesResultLimit.intermediateLimit"] = 4000000
# cube.shared_context["queriesResultLimit.transientLimit"] = 40000000

Enabling the ADVANCED_APP_EXTENSION leads to another interesting problem. I configured the queriesResultLimit.intermediateLimit up to even 10000000 (higher than the shared_context value which worked), the query simply won't run.

Below shows how we can modify the cell metadata in JupyterLab previously:

Referring to the state editor, I have added the configuration at the same level as the query. It seems to be taking effect based on the changes in the error message. However, similar to the UI, I'm not sure what is the value I need to set in order for it to work:

{
    "atoti": {
        "widget": {
            "filters": [
				...
            ],
            "queryContext": [
                {
                    "key": "queriesResultLimit.intermediateLimit",
                    "value": "5000000"
                },
                {
                    "key": "queriesResultLimit.transientLimit",
                    "value": "5000000"
                }
            ],
            "mapping": {
				...
            },
            "query": {
				...
            },
            "serverKey": "default",
            "widgetKey": "pivot-table"
        }
    },
    "tags": []
}

[bloussou]

Set it to -1 to have no limit maybe