Calculated view displays no results

[Former Member]

I have a calculated view that consumes various other calculated views.  One of the calculated views that's being consumed displays data when ran independently.  However, when a calculated view consumes this particular view, no data is shown.   I created a simple calculated view that simply consumes this problem view -- no filters, no additional logic.  Still get no results.  Is there anything I'm missing? 

[SergioG_TX]

are you adding any filters? are you able to activate it? can you provide any screenshots or error messages?

[Former Member]

In the test CV that I created, there are no filters and I mapped the parameters from the problem CV.  I am able to activate it and do a data preview -- but no data is returned.

There are no errors.  Just

[lucas_oliveira]

Hi Shadi,

Take a look at 'default client' options in Semantics tab. If this is set to 'Session Client' then you're model CLIENT/MANDT is being filtered with the CLIENT/MANDT value set at your DB session. Usually, that's set to empty on HANA (or 001, can't recall to be honest).

If that's the case, then just set it as 'Cross Client'  and run your calc view again.

If the issue persists go through the PlanViz filtering and find out who's filtering your data out

By the way: this sort of question appears regularly here in SCN. A very quick SCN search gave me lots of results...

http://scn.sap.com/search.jspa?peopleEnabled=true&q=no+results+calc+view&Submit=Search

BRs,

Lucas de Oliveira