To resolve these issues and get accurate display of values we have to follow below steps while merging dimensions.Ī) Add both data provider and their objects in Query Panel.ī) In excel data query dimension on which you are going to have your merge dimensions set their Qualification as Detail. If we try to show a key figure with any dimension variable and unmerged dimension of excel together then “#Datasync” or “#Context” error will occur.Įven if we drag one data provider dimension and drop beside another data provider’s dimension then system gives “Cannot drop here – the object is incompatible” error. Since there are two different data providers in webi and we need to show each other key figures based on cross dimensions, issues which we face are: Issue that can occur while merging dimensions In order to show key figures based on single dimension from both data providers we have to merge common dimensions in webi. We have 2 data providers one is from Universe that is built on Bex query and another data provider is excel. Select and merge Universe and Excel files as Data Provider Also how to validate universe data based on excel column. This document describes the how we can merge Universe and Excel datasource in webi and issue that could occur while doing merge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |