Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support for TMSCHEMA tables to test SSAS tabular model #616

Open
shiv24saxena opened this issue Dec 8, 2020 · 2 comments
Open

Support for TMSCHEMA tables to test SSAS tabular model #616

shiv24saxena opened this issue Dec 8, 2020 · 2 comments
Milestone

Comments

@shiv24saxena
Copy link

Currently Tabular model metadata is also getting verified against MDSCHEMA tables which are mainly meant for multidimensional model.
Tabular model metadata information is stored in TMSCHEMA tables which should be used to test the model.

Thanks

@Seddryck
Copy link
Owner

You're right but could you be a bit more specific on what's going not well with the current implementation?

@shiv24saxena
Copy link
Author

Thanks for responding. Few scenarios where current implementation will not work:

  1. In Tabular model to get mapping between Technical column name (Database field example FIRST_NM) and business column name (example - First Name), we need use TMSCHEMA_COLUMNS. Same information can't be retrieved by DBSCEHMA_COLUMNS.
  2. To get perspective details in case of tabular model, we need use TMSCHEMA_PERSPECTIVE_TABLES and TMSCEHMA_PERSPECTIVE_COLUMNS table. Same can't be retrieved from MDSCHEMA_DIMENSIONS which I believe is getting used currently,
    Please let me know if any other information/scenario is required.

@Seddryck Seddryck added this to the v1.24 milestone Feb 27, 2021
@Seddryck Seddryck modified the milestones: v1.24, v2.1 Dec 14, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants