TM1 Forum

Hi,

I've had a chore setup up to output a view daily. This view has a single value only and up until last week it worked fine. Now it creates no output file at all. There is data in that view, I can see it in the preview section on the datasource tab. I tried moving the piece of code to the Prolog tab and metadata tab, with no luck. I've tried changing the elements of that view, to isolate whether it was an element problem, but still no output. there has been no change to any system process. what's going on?

Data Tab:

sToday=date(dayno(Today(1))-1,1);
sDate = SUBST( sTODAY, 1,4) | SUBST( sTODAY,6,2) | SUBST(sTODAY, 9,2);

sFilename3='TM1_RollupBalance_'|sDate|'.DAT';
ASCIIOutput(sFilename3, NewAccounts, NumberToString(Value));

Thanks in advance

The preview window for a view data source is not indicative of data in the view as the preview does not respect the view (it cheats and merely pulls the intersection from element index 1 of each dimension.)

Probably either the view does not contain data or if the values are rule populated they are not fed.

hi! swain69,

try putting this,

ViewExtractSkipZeroesSet (Cube, ViewName, Flag); at your prolog where you create your source view -- where flag is a binary value that turns the option on or off. Specify 1 to exclude zeroes from the extract. Specify 0 to include zeros.

This function sets an option to include/exclude zero values in a view extract. A view extract is a TM1 view exported as an ASCII comma-delimited (.cma) file.


thanks!

bunchukokoy

lotsaram wrote:The preview window for a view data source is not indicative of data in the view as the preview does not respect the view (it cheats and merely pulls the intersection from element index 1 of each dimension.)

Probably either the view does not contain data or if the values are rule populated they are not fed.

Exactly. You need to actually check the view to see if there is any data, and not thru looking at the preview in TI. Right click on the View in Server Explorer and export it to a text file. If the file is empty it means your view is not returning any data.

Hi,

Thanks for your tips, it sent me in the right direction It turns out the following command was dropped from TI process for some reason, ViewExtractSkipCalcsSet.

I've had another process that after saving it lost some of the code. Fortunately I have backups, but why would this happen?