Current Position:Home > Table to check number of entries in an Infocube for a particular selection

Table to check number of entries in an Infocube for a particular selection

Update:11-30Source: network consolidation
Advertisement
Hi All,
Is there a table in BW system which would give a the number of entries in an infocube for a particular selection just like the flatR/3 table which has the button on top for checking the number of records?
Any close work around to check the number of entries in an Infocube would be appreciated.I have tried to find out the number of entries from F & E table but in vain.

The Best Answer

Advertisement
Hello,
You can try the following:
1) Right click on cube display data, select all attributes and nav attributes yo are interested in
2) Go to field selection for output, here select only the nav attribute you want the no of records against (dont select any KF) , hit execute
3) In selection screen provide the selection you want to give
4) Scroll down, uncheck do no use nay conversion and use mat aggregates, keep Max no of hits blank
5) Check use DB aggregation and output no of hits
This will give you the number of records for the nav attribute value u have selected.
You can use sum function in the ALV GRID if you want to sum up multiple values.
Regards,
Shashank
  • Table to check number of entries in an Infocube for a particular selection Update:11-30

    Hi All, Is there a table in BW system which would give a the number of entries in an infocube for a particular selection just like the flatR/3 table which has the button on top for checking the number of records? Any close work around to check the nu

  • Copyvalue from context -- check number of entries Update:11-30

    Experts, Iam facing an issue where i need to copy values from the first entry only if there are no more entries in the context Sometimes i see multiple entries in the context. each entry in the context is sent to the new record as a field value.so i 

  • Problem in finding table for check no. Update:11-30

    Hi Experts, I need to print the check number in my form, but the functional person gave the table name as REGUD, but it is a structure. Can any one let me what would be the table for check number(REGUD-CHECT) and bank name(REGUD-UBNKA). Thanks & Rega

  • Check number print with two zero starting Update:11-30

    I want add to zero before check number, example 4562  to be printed as 004562. SELECT 'xxxxx' as 'Debit A/c No', T1.DocDate as 'Date', T1.DocNum as 'Txn Ref', T1.CardName as "Benificiary Name", 'CHK' as 'Payment Type', T1.DocTotal as 'Payable Am

  • Number of entries in each table Update:11-30

    Hi, I have a requirement to find the number of entries in each table in the system, how do I find this? If I have to goto each table & find out it is a tedious job. Do we have any standard report kind of thing to find out the number of entries in all

  • Number of Entries in Dimension Tables and Fact Tables Update:11-30

    Hi all, is there an easy way to check - the number of entries in the dimension tables - the number of entries in the fact table? Thanks  a lot AlexHi Alex, If u want to see the content of Dimension table and Fact table for a infocube then just right

  • How to find out Number of entries in a Huge Table? Update:10-11

    Hi, I would like to know Number of entries in table DFKKOP. when i try to get it through se16, it takes more than 10 minutes in dialogue process so a time out occurs. is there any way to find out number of entries in the table Apart from creating a p

  • Give me a way to count the number of entries in a  Database Table Update:10-11

    Hello All, I am writing a code to determine the number of  entries in a SAP/Custom table. Can you please suggest a proper approach and a good query. Thanks in advance.Hi, If you want to do it in a more generic way you can do the following: DATA: tbln

  • To to number consecutively entries inside a table Update:11-30

    Hello everybody, I need to to number consecutively my entries inside a table like this: Heading1      1.Entry one      2.Enty two      3.Enty three      My table in the template looks like that: Heading 1      <?for-each-group:current-group();./ID?>

  • Maximum Number of Entries for Upload in Custom Table Update:11-30

    Hi All, I have a requirement to create a custom table, and then a custom program will be used to upload the data entries. The user is expecting to upload more than 5000 entries at one load. However, the program is encontering a dump. Is there a maxim