cancel
Showing results for 
Search instead for 
Did you mean: 

Differente result Between hana views and web intelligence

former_member219865
Participant
0 Kudos

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:

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member219865
Participant
0 Kudos

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

amitrathi239
Active Contributor
0 Kudos

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

former_member219865
Participant
0 Kudos

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.

former_member219865
Participant
0 Kudos

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

amitrathi239
Active Contributor
0 Kudos

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.

amitrathi239
Active Contributor
0 Kudos

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

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

former_member219865
Participant
0 Kudos

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]