on 07-14-2009 5:50 AM
Hi Experts,
Suppose if i want to execute the query with BIA option, I can achieve it in RSRT .
1)But is there some query settings or properties where we can make sure that whenever a query(say Q1) is executed, always the data should be fetched from the BIA index.
2)Suppose the BIA indexing has failed due to some reasons, will the data be fetched from the previously updated BIA index??
regards
akshay
Hi man,
1)But is there some query settings or properties where we can make sure that whenever a query(say Q1) is executed, always the data should be fetched from the BIA index.
If you have built up BIA index on a cube, then every query on the cube or MultiProvider will automatically use BIA index. No additional settings required. You can use the following way to test whether a query is using BIA or not:
Go to RSRT, input query name, click 'execute and debug' and check 'Display Statistics Data' and 'Do Not Use Cache'. Execute. After the query result press F3, now you should be able to see statistics. There's a tab 'BIA Access'. If you see something there then it means BIA index is used.
2)Suppose the BIA indexing has failed due to some reasons, will the data be fetched from the previously updated BIA index??
If BIA rollup is failed, then the last request(s) would not available in reporting and query will use BIA index for earlier requests. You can consider it like aggregate. But if initial fill of BIA failed then you would not be able to use BIA index.
Regards,
Frank
Edited by: Frank Lee on Jul 14, 2009 2:22 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1) Could you please elaborate a bit more on this requirement? I would say that this scenario is not that typical, that I would see.
2) Yes. The "Commit" step is the very last in the indexing process. If anything fails before it - original BWA Index is still valid. If you look into InfoCube -> Manage, you'll see which requests are reportable.
Regards,
-Vitaliy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
23 | |
11 | |
9 | |
9 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.