I want to export a file with attribute data, meaning attribute name and type. So I though it would simply be an export of the cube
'}ElementAttributes_' + Dimensionname
When using '}bedrock.cube.data.export' with my own created cubes, it works fine. But when using an }-Cube nothing happens.I only changed the cube name, nothing else!
Any idea?
Export }-Cubes with Bedrock
-
- Posts: 68
- Joined: Tue May 08, 2012 8:29 am
- OLAP Product: TM/1
- Version: 11.8
- Excel Version: Excel 365
-
- Posts: 68
- Joined: Tue May 08, 2012 8:29 am
- OLAP Product: TM/1
- Version: 11.8
- Excel Version: Excel 365
Re: Export }-Cubes with Bedrock
Sorry, found a solution by myself. Instead of exporting the cube, I can export the dimension '}ElementAttributes_' + Dimensionname.
-
- MVP
- Posts: 3698
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Export }-Cubes with Bedrock
The process }bedrock.hier.export will include all attribute names and type in the header, before the body which contains the hierarchy structure and attribute values. So if you want the attribute values it will be in that file.
If you aren't interested in the structure you could always just ignore all rows starting with "E" and "P".
If you aren't interested in the structure you could always just ignore all rows starting with "E" and "P".
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 68
- Joined: Tue May 08, 2012 8:29 am
- OLAP Product: TM/1
- Version: 11.8
- Excel Version: Excel 365
Re: Export }-Cubes with Bedrock
Thanks, I will use it.