on 04-10-2015 3:43 PM
I have a lot of Calculation views in HANA that are 'Dimension' rather than 'Cube' variety.
I would like to display my dimension data in Excel.
However, when searching for HANA tables using Analysis For Excel, I am only able to see my cube views, and none of my dimension views.
Is this by design, or have I set something up wrong ?
If by design , why ?
How may I easily display my Dimension data in Excel ?
Hope some one can point me in the right direction,
Many Thanks
Yes, only OLAP (cube) views will be read with AAO.
If you want to see the non-cube view, you must include at least one measure. This has been done before using a dummy "counter" in the aggregation node, but base it on something meaningful like the lowest grain of data.
Regards,
Justin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.