Skip to Content
0

Differente result Between hana views and web intelligence

Jan 17, 2017 at 10:17 AM

70

avatar image
Former Member

Hi, i have the following issue, i get wrong data when execute a hana calculation view on web intelligence, this is the result on hana:

and this is the result in web intelligence:

1.jpg (27.2 kB)
2.jpg (69.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Jan 17, 2017 at 10:37 AM
0

is your universe pointing to the same Hana view (same server)?

instead of checking in the Preview mode,refresh the report and see..

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

yes, in fact if i agree another dimension to the hana view i can see this in web intelligence, the problem is about data, its agree in different way.

the select in webi is:

SELECT

NON EMPTY {[Measures].[StockDisponible],[Measures].[CantidadConsigna],[Measures].[StockEnConsigna],[Measures].[Valor_StockExistente],[Measures].[ValorStockCtrlCalidad],[Measures].[StockExistente]} ON COLUMNS,

NON EMPTY [MVGR4].[MVGR4].[MVGR4].Members

DIMENSION PROPERTIES PARENT_UNIQUE_NAME, [MVGR4].[MVGR4].[MVGR4].[MVGR4] ON ROWS

FROM [ZSTOCKS_V2]

0
avatar image
Former Member Jan 24, 2017 at 04:11 PM
0

still have this issue, i dont know solution it can be problem of the select of the query panel

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Can you edit the webi scripts and remove the "NON EMPTY" part from the sql and run.

i don't have idea from HANA side but it seems issue with "NON EMPTY" syntax.

check why it's coming in the SQL.might be something you have selected in the universe object propetries.

0
avatar image
Former Member Jan 25, 2017 at 10:57 AM
0

im not able to edit the query, anyway i could change option to bring empty rows but still dont bring me correct data


screenshot-1.jpg (62.8 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

I would suggest to raise ticket to SAP support team.They will investiagte and come back.

0
Former Member
AMIT KUMAR

the thing is, web intelligence only takes the many rows as i have data in this example i have 4 rows with data, and then take the first four values and assign the data to this dimensions.

screenshot-2.jpg (55.4 kB)
screenshot-3.jpg (20.0 kB)
0