I am buiding a whole reporting package in WEBI 4.0 and I've run into an issue. I have several existing merged dimensions in the report (e.g. Month, Year, etc) I just recently added several new queries (from different universes) and would like to add the dimensions that came over to the existing merged dimensions. However, I am unable to do this unless I unmerge the existing merged dimension and then re-merge all the dimension members again. As soon as I unmerge though, many of my reports are completely messed up and would have to be rebuilt.
Is there a way to add new dimensions members to an existing merged dimension without having to unmerge first?
Thank you so much in advance!
No I have not, or at least I do not think I have. I do not know exactly what workflow you are referring to. Do you have a link that references this workflow so that I can review it and attempt to use it? I believe my BO instance has the latest patch installed and I am still unable to perform the merged dimension edit but I need to verify this.
it's worth confirming your installed Patch level, because a number of fixes have been delivered in this area since Patch2.8 even, for example:
Filter error Webi shows #UNAVAILABLE when a filter is applied on a dimension which is merged.
Filter on Merge BICS dimension is not working
Refreshing a WebIntelligence document merged dimensions may generate an error.
User cannot create merged objects based on attributes in Web Intelligence.
We are running BO XI 4.0 SP2 Patch 9.
To recreate the issue, have a report with at least two queries from different data sources. Merge a dimension between those existing queries, let's say a dimension called MERGED_REGION. Now build a report using the merged dimension, MERGED_REGION.
Add in an additional query to a new data source. This query will need to have a dimension REGION as well. Now try and add it to the existing merged dimension MERGED_REGION. You will find that you cannot. The only way to merge this new dimensions witht he existing ones is to unmerge MERGED_REGION, which will break the report that you have built. You will then have to re-merge in all the REGIONS now into a NEW_MERGED_REGION. This is not ideal. It would be better if we could just add a dimension from a new query into an existing merged dimension without having to unmerge it first.
Here are the Release Notes for Patch2.10 : http://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000735576&_SCENARIO=01100035870000000202&_OBJECT=011000358700001362992011E
There is a further fix in P2.10 ADAPT01601528 - Refreshing a WebIntelligence document merged dimensions may generate an error. However, it's not clear if your 'region' is a detail attribute of customer, for example, in which case it might be ADAPT01576476.
Anyway, I would suggest that: if you adding in a new Data Provider in, much later during your development cycle, having to unmerge and remerge makes sense to me. This is because the entire webi microcube's aggregation and calculation contexts will need to be done from scratch, and the synchronization between those dataproviders is an entirely new analysis.
What does surprise me however, is that your saying you can't use the existing merged_dimension name?
I will try the new patch release but based on the description, I do not think it will resolve my issue specifically.
I want to correct what I said. I CAN use the existing merged dimensions (MERGED_REGION) even after adding in the new data source. However, that merged dimension will not include the REGION dimension of the new data source. To merge the REGION dimension with MERGED_REGION, i would have to unmerge MERGED_REGION and then re-merge all the REGIONs together into a NEW_MERGED_REGION.
I agree that I can see why this needs to be done. What I am suggesting is that it would be nice for this to happen behind the scenes so that i do NOT have to unmerge MERGED_REGION as that affects all the reports I have built using MERGED_REGION. Does this make sense?
Yes, it does make sense, but this puts it firmly into the realms of 'enhancement request'
You should log your interest here, and describe this feature for the product owners to review: https://cw.sdn.sap.com/cw/community/ideas/businessanalytics/sbowebi
search for terms "MERGE" first - there are loads of entries, so perhaps pick one and vote it up.
the thing with 'nice to haves' like this, is that for every person that argues their requirements one way, there will always be another developer who wants the other behaviour.
infact, have you evaluated the effectiveness of the 'auto merge extended dimensions' tickbox under document properties ?
FYI - this is planned to be re-implemented in BI4.1 next year.
the Ideas Place link for this planned 'enhancement' can be found here: https://cw.sdn.sap.com/cw/ideas/4229
I also have this issue, but tried a workaround which works for me -> go to the document properties of your webi report and turn on auto-merge dimensions. Refresh the report and it merges all dimensions which can be merged including your new dimensions which you just added via the new query. You can then unmerge dimensions which you don't need merged.
This is a bug in 4.0.
Got a work around though. It still involves unmerging the dimensions, but just reduce ur redevelopment efforts.
Wht i did is created a new Variable and assigned the Merged dimension to that variable.
eg: created a variable called Model (Merged) and formula : =Model (from Merged Dimension)
Now i am using this newly creted variable everywhere instead of directly using the merged dimension.
So now if i unmerge the dimensions and merge them again with new object, i only have to change this particualr variable and all the report works as before.
This has reduced my redevelopment efforts. Its still not the best solution but its working for me for time being.
Hope this helps.
I'm waiting for this also a long time. In the release notes of SP06/SP07, ADAPT01689840 was mentionned in the "Known issues'. So intented to be added, but finally not added.
Now, in the release notes of SP08, it is finally mentionned as being delivered :
In Web Intelligence, if “Auto Merge” is disabled for a document, you cannot add dimensions from newly
added queries to existing merged dimensions.
This problem is resolved
So. I just installed SP08 on a SandBox (in fact SP8.1, since we need to be at same level as our SP7.4 PRD-Environment; 704 is forward-fit to 8.1).
But I don't see a change in behaviour. As far as I can see, one can still not "edit merged dimension".
Am I missing something ? Or ? Has somebody already tested it ?
I just confirmed in SP08 and the workflow which is fixed using above mentioned fix request works fine.
Attached are the steps you can follow at your end.(remove txt from the name)
Please confirm if you are expecting or looking for something else.
Vivek, thanks for your reply.
But what your are explaining in your document, is exactly what I ment :
I see no difference in SP08 as opposed to earlier versions : one can still not edit exiting merged dimensions.
Your last sentence is : "You can unmerge the merged dimension & then add all 3, however this step is not intuitive, especially for the non-technical end users the customer has and was not required in XI 3" .
And this is exactly what we are looking for : the same functionality as in XI 3.1, where one simply can edit existing merged dimensions.
So I really would like to know what is exactly changed by this ADAPT01689840
has been removed this issue ?
I have the same problem, impossible to add merge dimension
because I have to unmerge all dimensions merged before...
Do You know if any workaround has been supplied ?
Wich is the service pack that resolve this issue ?
as we know on BI 4.0 is not possible to add object in merged objects.
This functionality has been introduced on BI 4.1 SP4(http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41_whats_new_en.pdf - pag28 on chapter 2.12.5) , regarding
BI 4.0 there is any planned Service Pack in order to add this feature ?