Question:
Sorry for my ignorance.
Is there any transaction for finding out the Fact table and Dimension tables ratio?. I read in some SAP Documentation saying the RSRV will give these information. I checked in that transaction but could not able to find which “test” can provide me such information.
Many thanks for your time.
_________________
Hari Kiran
I saw many times Impossible saying I'am possible.
Answer:
check transaction LISTSCHEMA... the ratio won't be given, but the necessary info to calculate it yourself is available
cheers,
El Belgio
Answer:
Hello,
I don't know if i understand your question but you can see fact table and dimensions in se11. Table: /BIC/D<dimension name> for dimensions tables or /BIC/F<cube name> for fact table.
Hope it helps you
Joana
Answer:
hey you are right there is a direct transaction or menu path to go through.sorry don't have access to system right now but if you are in cube maintenance, one of the menu options allows you to go into checking the database tables (or something like that) and from there you are table to run a check which then gives you the percentage of your dim compared to your fact. Based on SAP recommendation anything over (I DON't recall exactly right now) but let's say 15% you should address by breaking up the chars into more dimension or making into line items instead. sorry could not be of more help but just wanted to let you know that you are right there is something out there..will respond when i get access to the system and able to send you direct path.
regards,
Answer:
are you referring to:
Manage > Goto > Data Target Analysis ???
'cause that would take you to RSRV... in there you could check Database > Database Information about InfoProvider Tables (the 4th check)
is that what you're looking for?
El Belgio
Answer:
Goto Transaction RSRV > Elementary Tests> Database > Database information about the infoprovider tables and execute.
Bwquery
Answer:
Right click on the cube, and choose Object Overview.
Otherwise, go to Meta data, and select your objects.
There, you will find all details about them.
_________________
Laurent THIBERT
Business Connection Amerique
Answer:
Hey!!
El Belgio, bwquery. Thanks. Yes! I was looking for that test only. Good to see those percentages.
Hmm...
I should have spent more time before I post this query. .
Joana, Guest(?) and lthibert. Thanks as well for your time.
For others:
1) RSRV > Elementary Tests> Database > Database information "test" for the selected cube will give application log as follows:
Cube ZTTICHIST has 6 dimensions; 0 dimensions are line item dimensions
Table /BIC/DZTTICHIST1 has 16 entries. Size corresponds to 0% of the InfoCube
Table /BIC/DZTTICHIST2 has 148870 entries. Size corresponds to 74% of the InfoCube
.
.
.
.
Table /BIC/EZTTICHIST has 0 entries. Size corresponds to 0% of the InfoCube
Table /BIC/FZTTICHIST has 202108 entries. Size corresponds to 100% of the InfoCube.
Hmmm 74% .. I think I have got some work.
_________________
Hari Kiran
I saw many times Impossible saying I'am possible.