cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Need to combine 2 Characteristics from different Cubes in a Query Report

Former Member

on ‎2015 Sep 10 5:47 AM

0 Kudos
128

Hi Guru s,

I have a requirement where I need to combine Characteristic 1 from Cube A and Characteristic 2 from Cube B into a single column in Query Report. Please help me in the following.

TIA

-Vikas.

Show replies
Show replies
Answer
View Entire Topic
former_member185181
Active Contributor
‎2015 Sep 10 7:17 AM
0 Kudos

What characteristics are those? Do you want to combine the values in single column or do you want to display either of those based on an condition?

Show replies
Show replies
Former Member
‎2015 Sep 10 7:33 AM
0 Kudos

Brand from Cube A and Acc Material Grp from Cube B. I want the display as

InfoProvider    Brand/Acc Material Grp     Revenue

Cube A                        AA                          10

                                   BB                           20

                                   CC                          30

Cube B                         11                          40

                                    12                           30

                                    13                           20

former_member185181
Active Contributor
‎2015 Sep 10 7:38 AM
0 Kudos

Do you use BEx for reporting, if so try using virtual characteristics, if you are using BO, then you can create variable to achieve this using WebI

Are you on HANA? if so, you can create an analytic index with this logic and consume in reports.

Former Member
‎2015 Sep 10 7:43 AM
0 Kudos

I m using BEx for reporting. So how do I use Virtual characteristics?

Ask a Question