sap webi is not pulling all data from native HANA from Calculation view

[former_member327592]

Hello experts ,

I am having a strange issue , need your help.

I have Cost centr data in one Calculation view and WBS data in another calculation view .

When I try to combine both in HANA in a Calculation view and then build a WEBI report on top of it to display boh fields , data is showing only from WBS data but Cost centre field is coming as blank . However when I remove WBS field from Query panel in WEBI then Cost cntre data is displayed . We need to see both fields with data in WEBI.

But I can see the data in Data preview in HANA studio correctly .

Not sure what I am missing here . Any advice appreciated .

[ayman_salem · Accepted solution]

I tried to rebuild your sample and I got the right result.

I think the problem of uniion_1, as I see in 2.png, you have COST_CENTRE and POSKI in both projection (1 and 4), and the target has connection to both projection. (Target COST_CENTRE should have link to COST_CENTER Projection and POSKI to Other one)

Here is a screenshot of my test example:

...

And here's the data preview of calculation view from the Eclipse (? Is automatically added if the value is NULL - just by data preview in the Eclipse, it's not a value like I thought before)

I hope this will help you solve the problem

[former_member327592 · Accepted solution]

Hi Aymen,

Thank you for your comment . If i remove Input paramters in Hana , then I can not see data in Data preview , no data in webi too

[ayman_salem · Accepted solution]

very strange, in fact, if you remove (delete) the definition of the input parameter in hana, it should return all values. (No restriction).

Are you removed the values from IP or delete the IP in Hana? what I meant, delete all Iinput parameter and restrictions completely

[former_member327592]

Hi Aymen,

I have added POSKI as a dummy column at low level to the Cal view on which other Projection is using and then mapped in the Union . It seems this is working fine fine . I think because of IP we have to add in both projections .

Just want to say thank you for all your help.

Thanks

[deodutt_dwivedi]

Hi Manoj,

Check if by any chance you have applied a report level filter POSKI != BLANK on WEBI report.

Regards,

Deo

[former_member327592]

Thanks Deodutt for your response . This is now resolved by adding POSKI field to other projection .

[former_member327592]

Hi Aymen,

Thanks for your response. Still no luck yet . I have made Union same like your screen print but still issue is there . At a time I am only able to display either Cost centre or POSKI but not both .When I try to display both in the query panel nothing is displayed in WEBI. I have attached screen print for Union and IP variables in Hana. Am i missing any thing here ?

union.png

ip.png

data-preview.png

cc.png

poski.png

both.png

ip-hana.png

[ayman_salem]

can you test it without ip-hana?

I will rebuild it by me, and I will see if it work or not (my Text Example was without IP variables)

[ayman_salem]

I see in 1.png the ? by POSKI when COST_CENTRE has Values.

maybe it cause the problem bei WEBI. so, try to change it and test it again

[former_member327592]

Hi Aymen,

Thanks . You mean changing ? to blank value . POSKI values from one view and Cost_cetre are from another view . I have tried changing ? to blank , but still no luck .