cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in a query

Former Member
0 Kudos

Hi gurus,

I try to explain my problem:

I got an InfoCube with 5 InfoSources, one of them take on the IC only few informations, much less than other 4.

In the report when i do drill down on any fields which is charged from other 4 IS i got two rows and one has a lot of #...

there's a way to collapse into one row?

tnx

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Create a cube for one IS which takes less information and create a DSO for remaing 4 IS's then create a multiprovider for these.

Sample code

create start routine

TYPES TYPE_REF_DSO TYPE /BIC/AZDDLYANL00.

DATA ITAB_REF_DSO TYPE HASHED TABLE OF TYPE_REF_DSO WITH UNIQUE KEY

OI_EBELN

OI_EBELP.

DATA WA_REF_DSO TYPE TYPE_REF_DSO.

use select statement

SELECT * FROM /BIC/AZDDLYANL00 INTO CORRESPONDING FIELDS OF TABLE

ITAB_REF_DSO.

former_member207028
Contributor
0 Kudos

Hi,

select all the charecteristcs common across all infosets in Cube at characteristic Indentification tab. and try executing the Query.

Regards

Daya Sagar

former_member181953
Participant
0 Kudos

when you don't have same character vaue from the rows in your cubes it displays as unassined (#) meaning there is no char but some values are posted ot it.