BIA question...

[Former Member]

Hi,

I have activated the BIA index for some of our cubes for our testing purpose. Now if BIA is active for a cube the query first checkes if data for report is available in OLAP, then it check if BIA is active for this cube and at last it reads from Cube if both are not available.

How can I make sure that the query has used BIA index?

Is there is any table where it writes a staistics information?

Please let me know if anybody has any idea about this.

Thank you everybody in advance.

SC

[Former Member · Accepted solution]

Hi,

I have read few posts here and found that the table name is RSDDSTATTREX.

Well, I have created BIA Index for few cubes and when I execute the query, nothing gets written to this table. I have checked in RSDDSTAT that stats are on for this table.

Is there any other trick to it?

Please let me know if you have any idea.

Thank you.

SC

[klaus_nagel · Accepted solution]

Hi,

since all queries read the data from the BIA - if the BIA index is active for this InfoCube, there is no "real" need to check it.

But if you neverthelesse want to check it, you should go to the Query runtime statistic tables or the appropriate technical content.

The mentioned table RSDDSTATTREX holds the statistics for the BIA-index fill times, not the queries.

The table RSDDSTAT is no longer valid for the query/OLAP statistics. The new statistics information can be found in the tables/views:

- RSDDSTAT_OLAP for all Frontend and OLAP times, and

- RSDDSTAT_DM for all Datamanager times, i.e. the data read access times, either on the DB, the BIA, or a remote system if you use a virtual InfoProvider.

If you then execute a query, that reads data from the BIA server, go to SE16 and get the STEPUID of your query execution in table RSDDSTAT_OLAP. With this STEPUID you can select in table RSDDSTAT_DM the corresponding entries of the read access. Now in these rows you find in the column "aggregate" the entry <InfoCubename>$T if the data was read from the BIA server (techn. name of the BIA index). If the data was read from an aggregate you find the technical name of the aggregate, somthing like 1000xx there, or the name of the InfoCube.

Btw: make sure that you have turned on the statistics for the InfoProvider or the Query and have set the correct detail level(transaction RSDDSTAT) otherwise you will not see what you want.

You can also use transaction RSRT1 and the debug-option "show statistics". After you see the query result, press F3 and you see two Tabs with the OLAP/FE and the Datamanager statistics.

Of course you can do the whole analysis much easier using the technical content for the query runtime statistics, but this here can be used as a quick check.

Hope this helps,

Klaus

[Former Member · Accepted solution]

Thank you Klaus for comfirming the difference between the BIA-index fill stats and Query stats.

I do see naming convention of <InfoCubename>$T in RSDDSTAT_DM and RSDDSTAT_OLAP tables.

Now my question is that my RSDDSTATTREX is still empty. Everything is set to default in RSDDSTAT. You have said that set it to appropriate level to see something. Does it have to be at some specific level to see that BIA-index fill statistics. I read the help.sap.com also and it says that -

The statistics have to be switched on for the relevant InfoProviders. You make this setting in statistics properties maintenance on the Data Warehousing Workbench screen; choose Tools-->Settings for BI Statistics, which is nothing but a RSDDSTAT transaction.

It seems like the Stats related to Query and cubes are on because I can see that data is available in RSDDSTAT_DM and RSDDSTAT_OLAP table but the table RSDDSTATTREX is still empty.

Please suggest if anything is missing here.

I will appreciate your suggestions.

Thank you again for a detail response.

Thank you.

Sume.

[Former Member · Accepted solution]

Hello Klaus,

Based on your statement below, what do you means?

you can do the whole analysis much easier using the technical content for the query runtime statistics

Any inputs would be greatly appreciated.

Thanks,

Niki

[Former Member]

Hi Sume,

Set the Detail level of statistics capture OLAP Detail level to 2 and check RSDDSTATREXSERV table. It should record the BIA breakup times (Trex kernel time, trex client time, RFC server time and abap rfc time).

Thanks,

Srikanth.