TM1 Forum

Hi There

I am trying to run an ASCIIOUTPUT on a CELLGETS function in TM1 10.1.

my code is below for the CELLGETS and ASCIIOUTPUT. In the CELLGETS, I know there is a value in the combination that is contained in the formula but I want the TI to produce an ASCIIOUTPUT. I dont know if my syntax is correct because i am getting "" blank in my output file but I know there should be a string.

PLE = CELLGETS ( cubSource , 'Original', ManagementEntity, PurchasingManagementEntity, 'C100V', Channel, 'Local' , Region, ProductLine, 'IO', PACProductSKU, RefMYF, 'Purchasing Legal Entity ') ;

ASCIIOUTPUT(sUserLogFile1, PLE, cubSource , 'Original', ManagementEntity, PurchasingManagementEntity, 'C100V', Channel, 'Local' , Region, ProductLine, 'IO', PACProductSKU, RefMYF, 'Purchasing Legal Entity ') ;

Any idea what could be wrong?

thanks

Hiten

hpansar wrote: my code is below for the CELLGETS and ASCIIOUTPUT. In the CELLGETS, I know there is a value in the combination that is contained in the formula but I want the TI to produce an ASCIIOUTPUT. I dont know if my syntax is correct because i am getting "" blank in my output file but I know there should be a string.

PLE = CELLGETS ( cubSource , 'Original', ManagementEntity, PurchasingManagementEntity, 'C100V', Channel, 'Local' , Region, ProductLine, 'IO', PACProductSKU, RefMYF, 'Purchasing Legal Entity ') ;

ASCIIOUTPUT(sUserLogFile1, PLE, cubSource , 'Original', ManagementEntity, PurchasingManagementEntity, 'C100V', Channel, 'Local' , Region, ProductLine, 'IO', PACProductSKU, RefMYF, 'Purchasing Legal Entity ') ;

Any idea what could be wrong?

I assume you mean that just the PLE field of the output file is empty, not that the entire line is.

There's no way of telling without knowing the structure of your cube (since we have no way of telling whether all of the elements are supplied to the CellGetS), though it appears that you are outputting all of the elements to that file as well.

What I'd therefore suggest doing is taking those values and feeding them into a DBR formula in Excel and seeing whether they do in fact return a string. There's nothing obviously wrong in your code that I can see, which makes it more likely that the issue is with the element selections not being what you believe they are.

Ok re read this sorry,

I would suggest setting a counter into play to see if its actually looping through, your numbers should be in the asciioutput

What is the TM1 error anyway?

macsir wrote:What is the TM1 error anyway?

Nobody had mentioned an error up to this point. The OP indicated that the file just has empty output in a field where a value was expected.

Yeah, as long as TM1 doesn't prompt any error, the syntax should be fine. I am wondering if there is a string value from that cubSource and the code here doesn't tell us much.