I have a weird one which I haven't encountered before, and can't find a reference to in a forum search. I was curious about whether anyone else has come up with it.
We're exporting values from some }ElementsAttributes cubes to a text file. This has been tried both through TI (using an "All" view as a data source) and also by directly right clicking on the cube and exporting.
Zero suppression is not used, consolidation suppression is not used.
On some, not all dimensions, we get empty strings for numeric attributes. It doesn't matter whether the attribute is populated with a non-zero value or not, it just comes out as an empty string.
On other dimensions, numeric attributes come out just fine.
Blowing away the }ElementAttributes cube and repopulating the whole cube made no difference.
If we zero suppress the view, we still get the rows which have non-zero numeric values... but again with empty strings as the value.
This was found (with the same dimensions) on both 9.0 SP3 and 9.5.2.
Has anyone else encountered this?
}ElementAttributes cube export excludes numerics.. sometimes
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
}ElementAttributes cube export excludes numerics.. sometimes
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.