HANA Analytical View Display Data Issue

[Former Member]

SAP Experts,

Need your kind help for the below issue,

I've created an analytical view from a DSO Active Table in HANA Studio. Through IDT (Information Design Tool), when I tried to view the contents of this DSO table (AYPURDA0100) by connecting to HANA, I see the following error which is mentioned below,

Error:

Error while refreshing the data provider.

Cause of Error:

[SAP AG][SDBODBC DLL][HDB] General error;7 feature not supported: cannot execute select * on olap cube: zthd/AYPURDA0100: line 1 col 26 (at pos

Note: The AYPURDA0100 table contents are displayed in HANA Studio. However when a view was created with NO join conditions for the same table with few selected fields including measures, the display data is not working.

Your views are greatly appreciated. Thank You in advance.

[Former Member]

Did you use a measure (number value) in your querry?

I had the same erroe, because my querry did lack a measure. Putting in some, helped.

Be careful testing your original table date by data preview in the IDT data foundation in tables without measures...this fails as well.

[former_member183750]

You'll be better off posting to [this|http://forums.sdn.sap.com/forum.jspa?forumID=491] forum. I'd move your post, but don't have the rights to this particular move.

Good luck,

- Ludek

[Former Member]

Thank you. Moved the post to the relevant forum.