This is a continue post from my previous topic
Reports with Multiple Data Provider (Universe and
External source) and Merged Dimension:-
·
If your report has merged dimension then it
will disappear (if automatic merging is off) after the migration.
·
If your report has merged dimension then it
will disappear and automatically re-created (if automatic merging is on) .This
option is not applicable for external source, so if you had an merged dimension
which includes object from universe and external source then it will not work,
you have recreate it manually
·
Variables, breaks, filters… created based on merged
dimension will be destroyed.
·
Variables which uses the merged dimension will
get changed into some wired character.
Reports with Detail Variables associated dimension using merged
Dimension:-
You will receive any
error message saying an error has occurred if you have any detail variable with
associated dimension using merged dimension, the report will not migrate
Workaround:-
Edit the detail variable and change the associated
dimensions to single data provider variable and do the conversion, after the
successful conversion of the report, change the associated dimensions back to
merged dimension.
External Source Data Provider issue:-
The
external data provider internally keeps the reference of the universe. So you
need to re point (simply refresh) to make a connection with the new universe
else you will receive an error message
Result from another query :-
This
option will through an error message, it better to remove the refresh during
universe migration and re point it after successful migration
Report Variable using merged Dimension:-
As
you have learned now, report variables will be destroyed if they uses merged
dimension and it has to be recreated after successful migration.
Workaround :-
Before report migration edit the
variable and make it dummy so that the report structure stays as it, update the
variable after the migration.
0 comments: