Sometimes it is necessary to check your data model if it still fit your needs. For this you can use the transaction rsrv. Select there under All Elementary Tests >> Database >> Database information about InfoProvider tables.
Now you can enter one InfoCube and choose Transfer. Now you can add more tests or click Execute to run the test.
![Enter Parameter Entry for database information](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/i3db7d88e8e71a33b/version/1490037927/enter-parameter-entry-for-database-information.png)
After you click execute, you will see the log.
![Log about the test](https://image.jimcdn.com/app/cms/image/transf/none/path/s1c89cca4309ebad9/image/i1c22db336f0820bc/version/1490038124/log-about-the-test.png)
As you can see, the design of dimension 2 is very bad. It contains 100% of the entries of the f-table. So now we can plan our redesign. You can also check your cube design with the report SAP_INFOCUBE_DESIGNS. How important a good InfoCube design is, will I show you in a futher post.
These posts might also be interesting:
author.
I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.
![](https://image.jimcdn.com/app/cms/image/transf/dimension=250x180:format=jpg/path/s1c89cca4309ebad9/image/ifbcbd6254b84b440/version/1579612443/image.jpg)
![](https://image.jimcdn.com/app/cms/image/transf/dimension=250x180:format=png/path/s1c89cca4309ebad9/image/iceb7c340a3cdfd11/version/1547207729/image.png)
![](https://image.jimcdn.com/app/cms/image/transf/dimension=250x180:format=png/path/s1c89cca4309ebad9/image/i33303fc1b6cc6323/version/1522747916/image.png)
Write a comment