Skip to Content
0

join 2 Data Sources in 2 Crosstab

Jun 15, 2017 at 02:16 PM

67

avatar image

Hi, i Need to join 2 Queries in one Crosstab. I use Design Studio 1.6 and Import the Data Sources from BW. I have tried it with BYO DS. Nothing works. Can somebody help me?


I Need something like this:

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mustafa Bensan Jun 15, 2017 at 02:53 PM
1

Hi Piotr,

For best performance and as a best practice, ideally you should link the two InfoCubes with a MultiProvider in BW and create a single BEx Query over the MultiProvider, rather than attempting to merge the data sources client side. If you must however, you can apply the approach described in the post Data Blending with Data Iterator and BYOD.

Regards,

Mustafa.

Share
10 |10000 characters needed characters left characters exceeded
Piotr Kozlowski Jun 16, 2017 at 06:54 AM
0

The Approach described in the post does not work. There is a warning on start "The application has been saved in an older Version of the design tool. Saving any changes in the newer Version will make the application incompatible with older design tool installation". I can see only blank Screen.

I Need to merge data sources also for another Projects, anyway I want to know how to do it.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Piotr,

Only the way "Mustafa" has been suggest is best. If you are facing any issue. Please share your screen shots.

Regards,

Vidhya.C

1

Hi Piotr,

This is because 'SCN_OWN_DATASOURCE_BUILDER-20160310173344' Design Studio Application file was built on a Design Studio version that is prior to the one you are using. As the blog title mention DS1.6 if you are using the same then just find the right Service Pack. It should work then.

0