Skip to Content
author's profile photo
Former Member

Reporting view

Hi all,

I had a requirement..

FOR ONE REPORT

Data is coming through the table: SKA1 and some account groups to be picked from KTOKS (G/L account group)

they are: SATX, MFCG, OTHR, CONS..

and from BSIS/BSAS table select BUKRS, GSBER, HKONT, GJAHR, MONAT, DMBTR, SAKNR and WRBTR....

From the above information i have to generate sales and EBITDA report...

I have already extracted 0GL_ACCOUNT_T011_HIER from R/3

So, overall FSV has succesfully come to BW..

My Doubt is Now how to proceed inorder to generate a report??

What is the DataSource and InfoCube to be used???

Please help me....urgent...

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 12:45 PM

    Hi,

    According to my understanding:

    Now data is available in BW.

    Means there must be infoobjects and Keyfigures related to the data.

    And If I am not wrong there is a infoprovider like ODS or Infocube.

    So taking that infocube as infoprovider,create a query.

    Now use the required data where u want to use like row column etc.

    Hope it helps.

    Regards,

    Tulasi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I mean I do not have G/L account group in BW Business content...

      How to consider G/L account group??

      How to generate a report??

      Shall i generate a report on InfoObject G/L account (or) Create a Generic DataSource and then assign to corresponding Infosource and Creating InfoCube etc...

      Get Report????

      Pls suggest me....

      Thanks...

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:12 PM

    Create a View based on these tables and check the relation if that exists and create a Custom Data source and based on your requirement Full or Delta can be handled via DSO or IC.

    Regards,

    Andy

    Add comment
    10|10000 characters needed characters exceeded