INAPP Checkbox use

[Former Member]

Hi,

I was told that the INAPP check box is used to define whether its stored in a SQL or OLAP database. However when i go to SQL database enterprise manager i see no difference between a SQL and INAPP database. May i know a real life example how a SQL and database looks like and their difference?

[PatrickFavre · Accepted solution]

Hi,

Use the InApp option to set where dimension properties are stored. You can store dimension properties in the application database and the BPC SQL database, or in the BPC SQL database only.

Storing dimension properties in the SQL database gives you better performance. However, you cannot store properties in SQL that you will need in dynamic expansions or other MDX-type queries, such as from Dimension Formulas. Properties that are referred to in MDX-type queries must exist in the application database. The system will not allow you to move required properties to SQL. For other properties, you need to know whether you will query the properties using MDX-type queries.

Hope this will help you.

Kind Regards,

Patrick

[Former Member · Accepted solution]

Hi,

I need to know how a sample SQL database looks like and an application database looks like. Where can i see a sample of each in real? I believe i can see the SQL database in MS SQL Enterprise but how about the application database, where can i see it?

[PatrickFavre · Accepted solution]

Hi,

Application database in that case is called a Cube, and you can see it with Analyis Service in SQL server Management Studio.

Hope this will help.

Regards,

Patrick

[Former Member · Accepted solution]

Hi,

I don't see any nodes called analysis service in SQL Server Management Studio. Where can i see it?

[PatrickFavre · Accepted solution]

Hi,

Did you enter SQL server management studio with Server type "Database Engine"? If yes, you should have chosen "Analysis Services" there. And if "Analysis Services" is not available in this drop down, it means SSAS has been installed on another server.

In that case, you should know the name of your SSAS Server and you should be able to connect to it via the "Connect" button in the Object Explorer Window" when being in Management Studio "Database Engine" mode.

Regards,

Patrick

[Former Member · Accepted solution]

Hi,

I managed to go to analysis service, but in the cubes node i can't find the dimension properties which i have set as INAPP. Do you know why?

[PatrickFavre · Accepted solution]

Hi,

Ok, in SSAS, click under the dimension node, then chose the dimension where you would like to see INAPP properties.

Right-click on this dimension and chose Browse. Then a new "Browse" window opens, and you click on the button "Member properties".

Regards,

Patrick

[Former Member · Accepted solution]

Hi,

Yes i did but the member properties just show all the dimension properties. It does not differentiate between INAPP and non-inapp.

[PatrickFavre · Accepted solution]

Hi again,

No... I mean, there are several properties which are added automatically by SSAS when building your cube, such as CALC, SEQ, HLEVEL etc...

All dimension properties not flagged as INAPP in BPC admin console should not appear in this browsing list.... or you did something wrong.

Regards,

Patrick

[sorin_radulescu]

I suppose you are speaking about INAPP propety for dimensions property.

If a property of dimension have InAPP then this dimension will be visible into cube.

If a property doesn't have InAPP then this property wil not be visible into cube.

This the only difference.

from SQL Server point of view is no difference.

So always you have to check InApp just the property which you will use it for reporting.

For example properties used for consolidation (which is done just at SQL level) you don't need to be InAPP.

I hope this wil help you to understand when you have to use InAPP and when not.

Keeping less properties into cube dimensions you will have a smaller cube and the performances for retrieve will be better.

So it is important to avoid to have for all properties of your dimension the option InApp selected.

Regards

Sorin Radulescu