raw mode in query() does not use the default simulation by default

[bloussou]

Hello,
I think raw and pretty queries should return the same results. It is not the case when doing a query on a cube with a parameter simulation:

import atoti as tt
import pandas as pd

TUTORIAL_RESOURCES = "python/atoti/atoti/tutorial/data"

session = tt.Session()

sales_table = session.read_csv(
    f"{TUTORIAL_RESOURCES}/sales.csv",
    table_name="Sales",
    keys=["Sale ID"],
)

shops_table = session.read_csv(
    f"{TUTORIAL_RESOURCES}/shops.csv",
    table_name="Shops",
    keys=["Shop ID"],
)

sales_table.join(shops_table, mapping={"Shop": "Shop ID"})

cube = session.create_cube(sales_table)

l, m = cube.levels, cube.measures

country_simulation = cube.create_parameter_simulation(
    "Country simulation",
    measures={"Country parameter": 1.0},
    levels=[l["Country"]],
)

country_simulation += ("France crash", "France", 0.8)

workaround:

cube.query(m["Country parameter"], levels=[l["Country"]], filter=l["Country simulation"] == "Base", mode="raw")

[bloussou]

My current guess is that it is not using the defaultValues for the Country simulation hierarchy, I don't know yet where I should get this information that is present in the cellset when doing a "standard" mdx query.

[bloussou]

Maybe this is not an issue and in gaq queries useres must specify which Country simulation value they want to use