on 03-10-2009 10:43 PM
Hi All,
I am new to BI. I am asked to download data form info cube to flat file.
I created a infosopke and provided (infocube) and selected all the infoObjects.
After running it it is created a .CSV file on my desktop but, it is only downloading the characteristics of all the infoObjects like (COLUMN;FIELDNAME;KEY;TYPE;LENGTH;OUTPUTLEN;DECIMALS)
How to get the data into the flat file from infocube.
Please help.
Thanks,
Shiva.
Goto tcode listcube -> give the infocube name -> next comes the selection screen, give your selections and also give the maximum number of rows, also press the button 'field selectn for output' and select the fields that you want in the output and press execute this shows the data of the infocube. Now use the manu list -> export -> local file and save this as a spread sheet.
Warm Regards,
Hari
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is the data reportable in your infocube? Also, can you give a sample of what is in the file, I can make several guesses, but I am not sure if I understand you correctly.
Brian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes reporting is done on this cube.
below is the data from the CVS file.
************
COLUMN;FIELDNAME;KEY;TYPE;LENGTH;OUTPUTLEN;DECIMALS
1;CHNGID;X;NUMC;000014;000014;000000
2;CHRT_ACCTS;X;CHAR;000004;000004;000000
3;CURRENCY;X;CUKY;000005;000005;000000
4;CURTYPE;X;CHAR;000002;000002;000000
5;DATE0;X;DATS;000008;000010;000000
6;FISCPER;X;NUMC;000007;000008;000000
7;FISCVARNT;X;CHAR;000002;000002;000000
8;FISCYEAR;X;NUMC;000004;000004;000000
9;FLAG;X;CHAR;000001;000001;000000
10;RECORDTP;X;NUMC;000001;000001;000000
11;REQUID;X;CHAR;000030;000030;000000
12;SEM_POSIT;X;CHAR;000016;000016;000000
13;TIME;X;TIMS;000006;000008;000000
14;USER_NAME;X;CHAR;000012;000012;000000
15;USER_SYST;X;CHAR;000010;000010;000000
16;/BIC/ZDOC_TYPE;X;CHAR;000004;000004;000000
17;/BIC/ZGLCONS;X;CHAR;000010;000010;000000
18;/BIC/ZLEDTYP;X;CHAR;000003;000003;000000
19;/BIC/ZUNIQUEID;X;CHAR;000032;000032;000000
20;/BIC/Z_COMCODE;X;CHAR;000004;000004;000000
21;/BIC/Z_GLCASA;X;CHAR;000010;000010;000000
22;/BIC/Z_LEDGER;X;CHAR;000002;000002;000000
23;/BIC/Z_PROITEM;X;CHAR;000012;000012;000000
24;/BIC/Z_VERSION;X;CHAR;000003;000003;000000
25;AMOUNT;;CURR;000017;000023;000002
26;BALANCE;;CURR;000017;000023;000002
Hi,
If I understand your reply correctly if you check the cube using transaction list cube then data is returned for the exact same selection that you make when you execute the infospoke, is this correct? Does the infospoke run correctly (has green status) but just returns 0 records? In this case you should make a dummy change to the cube (i.e change the description), 'save' this change and then reactivate the cube. Please also make a dummy change to the infospoke and same and reactivate. Afterwards please try the infospoke extraction again. If the problem still exists please check if you have the same issue if the target of the infospoke is a DB table and not a flat file. Please also let us know your BI release and support package level.
Best Regards,
Des.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.