on 09-25-2008 2:14 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
select all the charecteristcs common across all infosets in Cube at characteristic Indentification tab. and try executing the Query.
Regards
Daya Sagar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.