What are the naming conventions used for aggregates created
from query?
Answers were Sorted based on User's Feedback
Answer / vsu_vnaya
There are two types of aggregates generated from Query..MIN
and MAX. However, there name starts with 1.
. The table names that make up the logical object that is
the aggregate are then derived in a similar manner, as are
the table names of an InfoCube. For example, if the
aggregate has the technical name 100001, the fact tables are
called: /BIC/E100001 and /BIC/F100001. Its dimensions, which
are not the same as those in the InfoCube, have the table
names /BIC/D100001P, /BIC/D100001T and so on.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vsu_vnaya
As you know aggregates are baby cubes right.
Aggregate names by default system has given as 6 digit
number like 100831 but write the description by yourself.
Here you have to remember fact table is created with the name
like for ex: /BIC/F100831.
while creating aggregates you can observe all options
carefully till complete the creation process then after I am
sure about
your can get idea .
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vsu_vnaya
For aggregates generated by the system, the naming is
usually MIN or MAX. Also if it generates aggregates from the
statistics tables, then STAT is used. If you want to create
aggregates on your own, you can name them according to your
companies naming rules/conventions.
Is This Answer Correct ? | 0 Yes | 0 No |
How the query from BW is used?
what are the drawbacks of ods?
What is a free characteristic?
What are the tools to monitor overall query performance.
You have 3 cube for which you create multiprovider and a report. The data doesn't show up in the report. What went wrong?
What is the Bex options for characteristics like F4 help for query definition and execution?
In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.
why the loading set-up tables only for LO extraction.why not for other extractions like FI,CO-PA?plz gv me answer clearly..very need
my intermediate is mpc and my graduation is bcom and pg is mba. learnt sap bw and abap. tell me the interview questions for the same?
What do you do , when you get a GAP ? What is FIT-GAP analysis ?
What is the importance of 'start routine' in update rules?
What is the use of real-time infocube? How do you enter data in real-time infocubes?