G

Friday, May 13th, 2022 1:27 PM

Data Cubes - how to build the physical data dictionary?

Greetings! We have a number of data cubes - some IBM, some SQL Server, and absolutely no way to understand how to configure/represent them in Collibra, in a way that would make sense. It seems the data dictionary is a 2-dimensional repository. Has anyone successfully managed to ingest a 3-dimensional array or cube?

1.2K Messages

2 years ago

Have you reached out to coaching services? They are great for this type of modelling challenges.
In the meantime, can you share a few details on your challenges?
For facts and dimensions, those can be modeled as entity/attributes. What are the things that are difficult to model?

3 Messages

2 years ago

Nope, haven’t gone the coaching route yet - I have found it better to check the help files and the community prior to engaging other resources. The difficulty, for me, is how to represent data assets. Using a simple example, where the cube is showing the total sales figure for a given sales person, with a given product, in a given month, how would that fit into the physical data dictionary?
Thanks

3 Messages

2 years ago

Thanks, those are helpful, as far as they go, but neither talk to ingestion and structure of data cubes (Cognos or OLAP), which feed Tableau and Power BI. We’ll follow up with the Collibra rep we will be working with.

2 Messages

 • 

55 Points

4 months ago

Hi,
Currently facing a similar issue representing cubes in Collibra's physical data dictionary. Curious if you were able find a working solution?
Thanks

Loading...