on 02-14-2014 6:37 AM
Hello Expert,
I've been browsing on how BWA process query results in memory.
We have one cube having approx last 5 years of data store and this cube we have added onto BWA. Usually we query compare last two years data ( i.e 2014 and 2013). My doubts here , if query run with year 2013 data , does BWA bring all data into memory , I mean all cube's data and than extract 2013.
Any idea ?.
Thanks,
PNS
Hi,
It's possible with BW 7.3x onwards to use the option to have a BWA only Infocube, in other words loading all the data to the BWA (in memory). Otherwise, you will only have indexes in the BWA.
Thanks,
Diego Seben.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
BWA doesnot load the actual data. Only Indexes stores at blades. So if your cube is having last 5 years data and you are running the query for 2014 period then it will go through all the indexes first and then extract 2014 data from the result.
Regards,
Kake
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
i think you specify the year level filter in column level. So BWA take all the data into memory then do the filter based on the column level filter.
Regards
Sureshkumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your response Suresh.
But my actual doubts , does BWA load all cube data into memory and then do filtering.
As I explained , cube is having last 5 years of data and in query I am only selecting 2014 year - so does BWA load whole cube into memory and then extract 2014 from result set.
Thanks,
PNS
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
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.