Skip to Content

FSV and SAP BW Reports

sap-bw-report-and-ecc.jpg

Hi All,

I have Bex Queries 1. P&L, 2. Balance Sheet, 3. Cash Flow on virtual provider 0FILG_V10. I have loaded FSVs from ECC System to BW infoobect 0GLACCEXT.

At ECC side I can see hierarchy sub nodes but in BW Report itssap-bw-report-and-ecc.jpg missing. No restrictions at query level.

Please see the attachment for more details. Its urgent prompt response will be highly appreciated.

Thanks In Advance,

Asim

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • 6 days ago

    Hi Asim,

    Can you please check zero suppression is active in query once?I think that might be the reason.

    one more thing expand hierarchy at highest level

    Regards,

    Ganesh Bothe

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ganesh Bothe,

      Thanks for the reply. Zero suprression is not active in the query and also I have expanded hierarchy to highest level but still nodes are not coming.

      Regards,

      Asim.

  • yesterday

    Hello Asim,

    do you have transactional data on those nodes?

    The standard setting in a query is to show only posted values - if there is no data on a node, the node will not be shown.

    If you want to see all nodes int he hierarchy, no matter if there is something posted, go to the query, to the characteristic where the hierarchy is defined on, extended properties - set it to "show master data".

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Cornelia,

      Thanks for the reply.

      Transaction data is there for those nodes and data is visible at virtual cube but not at report level. I have also followed SAP notes 801313, 963603 but still no luck. Please suggest.

      Best Regards,

      Asim.

  • 4 hours ago

    Hi All,

    After selecting radio button "Only values from infoproviders" I'm able to see those nodes in Bex report but still values are not coming. Please let me know the BEX Query desinger settings for queries based on virtual provider.

    Regards,

    Asim

    Add comment
    10|10000 characters needed characters exceeded