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
JackLacava's avatar
JackLacava
Community Manager
3 years ago

IIRC they are bitmaps.

To be honest, I hate to be "that guy", but there are probably better ways to go about looking at your data. If you're trying to export raw data, look into the Fdx "Execute" calls, or the functions in Brapi.Finance.Data; they are more than enough to perform data extraction, as part of an extender or a Dashboard DataSet rule that can power a Data Adapter of type Method. If you're building reports, look at Cube View MD Data Adapters.