Export }-Cubes with Bedrock

Post Reply
schlemiel29
Posts: 50
Joined: Tue May 08, 2012 8:29 am
OLAP Product: TM/1
Version: 11.8
Excel Version: Excel 365

Export }-Cubes with Bedrock

Post by schlemiel29 »

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?
schlemiel29
Posts: 50
Joined: Tue May 08, 2012 8:29 am
OLAP Product: TM/1
Version: 11.8
Excel Version: Excel 365

Re: Export }-Cubes with Bedrock

Post by schlemiel29 »

Sorry, found a solution by myself. Instead of exporting the cube, I can export the dimension '}ElementAttributes_' + Dimensionname.
lotsaram
MVP
Posts: 3654
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

Post by lotsaram »

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".
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
schlemiel29
Posts: 50
Joined: Tue May 08, 2012 8:29 am
OLAP Product: TM/1
Version: 11.8
Excel Version: Excel 365

Re: Export }-Cubes with Bedrock

Post by schlemiel29 »

Thanks, I will use it.
Post Reply