Skip to Content
author's profile photo Former Member
Former Member

Check amount of data and tablespace

Hi,

in RSA3 I can check the extraction of a datasource. The thing is that I cant find out how much data really will come up in BW.

You have to select the number of data records there.

Is there another transaction that will show me exactly for a datasource how many records will come up in BW when starting full upload in the infopackage and show me how much space should be available in database?

And is there a transaction that will show me how much space is actually available in database to avoid an overflow?

thank you guys!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 17, 2011 at 02:30 PM

    Hey,

    I think the only transaction that will help you to see how many records will come in a transaction is SE16. You just have to know how the extractor work and which tables are selected. E. g. if you build up data for 2LIS_05_Q0NOTIF than you can go to table QMEL to see how many data is there. It is not always so simple because not every record from a main table for a datasource is always selected. But normally it should give you a good direction.

    Find main table for datasource and check in SE16.

    Do learn about database go to DB02 or DBACOCKPIT. There you can find information about the whole database and also single tables.

    I think to say in advance how many space is necessary for a datasource this is a little bit difficult. normaly you don't catch all fields of one table, other fields are enhanced. It also depends on your target structure. PSA would be simple, for DSO you have active and change log table to consider and InfoCube has a star schema with different tables where it mainly depends on your modelling.

    Maybe it can help you to search for topic BW sizing in SDN.

    Kind regards,

    Peter

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.