OLAP cubes

[salah34145]

Hello,

I have successfully completed the connection to the OLAP cubes. However, when attempting to select the dataset, the cube option (test) provides various schema choices such as information_schema, db_accessadmin, db_backupoperator, gest, sys, and odb. All schema options return empty tables, except for odb, which gives the following tables: msreplucation_option, spt_fullback_db, spt_full_back_dev, spt_fullback_usg, spt_monitor, and spt_values.

I was unable to extract the content I need from these tables. If anyone has insights or suggestions on how to resolve this, I would greatly appreciate your help.

Thank you!

[dosubot[bot]]

I found a similar open issue titled OLAP Cube Return Empty Tables, which might be related to the problem you're experiencing. However, this issue currently has no comments or solutions provided ^[1].

For your situation, ensure that you have the necessary permissions to access the data within the OLAP cubes. Specific roles and permissions are required in Apache Superset to access data sources. For instance, the Admin role has full access, while Alpha and Gamma roles have varying levels of access. You might need to verify that your user account has the appropriate permissions to access the data you need ^[2].

Additionally, check if the schema selection is correctly configured. Apache Superset allows users to select a database and schema within SQL Lab, and any unqualified table names should be in the selected schema. Ensure that the SQLAlchemy URI is correctly adjusted to run queries in the specified schema ^[3].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}