on 03-24-2015 10:14 AM
Hello Gurus,
We are in process of migrating our DB from Oracle to BW on HANA DB.
Question 1:
As an preparatory step we have to know what will happen to Physically partitioned Infocubes,
Is it enough if we execute the Transaction: RSMIGRHANADB (or program RSDRI_CONVERT_CUBE_TO_INMEMORY) with the physically partitioned infocube. or is it automatically converted to HANA optimized Infocubes or any special steps to be carried out for the physically partitioned cubes.
Question 2:
I read in some blogs that SPO cubes are automatically converted to HANA optimized.Does it means we need not run the SPO cubes in the transaction RSMIGRHANADB (or program RSDRI_CONVERT_CUBE_TO_INMEMORY) to convert?
Thanks.
Hi Meiyappan
As far i know there is nothing special about already partitioned cubes. However before the conversion i would suggest to apply all notes related to program RSDU_TABLE_CONSISTENCY and also for RSDRI_CONVERT_CUBE_TO_INMEMORY, to have an up to date version of them.
After this use rsdu_table_consistency to check all fact tables in the system, since an inconsistency can cause problems during the conversion.
Regarding the automatic conversion i'm not sure if that's really done, since the conversion program also has an option to convert SPO-s not only normal cubes.
br
Roland
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Roland,
Thanks for your reply.
What i assume with the programs RSDU_TABLE_CONSISTENCY and RSDRI_CONVERT_CUBE_TO_INMEMORY that these are used for all cubes consistency and not specific to partitioned cubes.
So any ways we run the programs as pre check in the system before the migration process.
Am i right in this case?
If yes,then i assume there is no special step required for physically partitioned cubes migration.
With Regards,
Meiyappan
Hi Meiyappan,
Answer to your questions
1) When you migrate your system to HANA , System ignores your partition clause at table level.So your Standard Partition cube at Normal DB after migrating to HANA becomes only Standard Cube. So to migrate it to HANA optimized you have to use RSMIGRHANADB transaction.
2) Which blog you are taking about here? no thats not right.You have to migrate even the SPO to HANA optimized manually.In RSMIGRHANADB transaction you have separate option to migrate the SPO objects.
Hope this helps..
Thanks & Regards
A.Dinesh
Hello Dinesh,
So I understand that the partition gets deleted after the migration and we have to recreate the partition once again if needed.
First Question:
Will data gets affected if the physical partition is deleted.?
Second Question:
Is it possible to partition if the cube is converted to HANA optimized cube.
Second Question:
Is it really required to partition the cubes after migration,since the performance of the cubes will be increased any ways after HANA migration.
With Regards,
Meiyappan
Hi Meiyappan,
Cubes in BW on HANA can no longer be partitioned,this option will be disabled once you run your BW application on HANA
Answer to your question
1) Data will not get affected
2) No its not possible
3) Its not necessary to partition because of HANA performace.
Please go through the below link to know more
hope this answers your question
Thanks & Regards
A.Dinesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.