update Cube
import pandas as pd
from mstrio.project_objects.datasets import SuperCube
from mstrio.connection import get_connection
PROJECT_NAME = '<Project_name>' # Insert project name here
SUPER_CUBE_NAME = "<Cube_name>" # Insert name of created suber cube here
SUPER_CUBE_ID = "<Cube_ID>" # insert ID of edited super cube here
conn = get_connection(workstationData, project_name=PROJECT_NAME)
stores = {"store_id": [1, 2, 3], "location": ["New York", "Seattle", "Los Angeles"]}
stores_df = pd.DataFrame(stores, columns=["store_id", "location"])
sales = {
"store_id": [1, 2, 3],
"category": ["TV", "Books", "Accessories"],
"sales": [400, 200, 100],
"sales_fmt": ["$400", "$200", "$100"]
}
sales_df = pd.DataFrame(sales, columns=["store_id", "category", "sales", "sales_fmt"])
ds = SuperCube(connection=conn, name=SUPER_CUBE_NAME)
ds.add_table(name="Stores", data_frame=stores_df, update_policy="replace")
ds.add_table(name="Sales", data_frame=sales_df, update_policy="replace")
ds.create()
ds.add_table(name="Stores", data_frame=stores_df, update_policy="add", to_attribute=["store_id"])
ds.add_table(
name="Sales",
data_frame=sales_df,
update_policy="add",
to_attribute=["store_id"],
to_metric=["sales_fmt"]
)
ds = SuperCube(connection=conn, id=SUPER_CUBE_ID)
ds.add_table(name="Stores", data_frame=stores_df, update_policy="update")
ds.add_table(name="Sales", data_frame=sales_df, update_policy="upsert")
ds.update()
ds.certify()