cancel
Showing results for 
Search instead for 
Did you mean: 

Infospoke data problem

0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

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

desgallagher
Contributor
0 Kudos

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.