Forum Discussion

Marcello's avatar
Marcello
Contributor
3 years ago

SQL Database IDs for Origin and Consolidation dimension

Hello,  I am trying to "translate" the system elements IDs of Origin and Consolidation dimension. I found that they are stored in the SQL database with the following IDs.   SELECT distinct [C...
Methodology
Marcello's avatar
Marcello
Contributor
3 years ago

Hi Giacomo,

thanks for the help.

For main cube reporting I think we will use "MD Data Adapters".

Our original goal is to enhance standard Onestream reporting on journals, for which we did not find any other solution that querying directly the DB tables. But on this topic we are struggling on IDs and security issues. Do you know if there is a specific way to access journal entries details using Onestream standard query tools?

Thanks,

Marcello