Jan-09-2018, 10:02 PM
Hi Team,
I have 6 SQL Cubes in an ETL, each Cube has various dimensions and measures fields. Each cube has a total of 800 parameter/fields.
These Cubes are dependent on different OLTP applications (which have their own databases locally). I am using report builder to as BI tool to validate the Cube Data matches the orignal OLTP application database. The challenge is many fields name in the cub is slightly different from the original field.
Can I use python to learn how to map my Cube Fields with the Local SQL table fields so it is easier to get the right fields in Report builder instead of searching 800 fields manually.
I have 6 SQL Cubes in an ETL, each Cube has various dimensions and measures fields. Each cube has a total of 800 parameter/fields.
These Cubes are dependent on different OLTP applications (which have their own databases locally). I am using report builder to as BI tool to validate the Cube Data matches the orignal OLTP application database. The challenge is many fields name in the cub is slightly different from the original field.
Can I use python to learn how to map my Cube Fields with the Local SQL table fields so it is easier to get the right fields in Report builder instead of searching 800 fields manually.