Hello everyone,
I'm trying to load act data from a source cube to a target cube via a TI-process. Should be pretty much basic. I created a view in the sourcecube, created the TI-process and run it. The process successfully completes... (immediatelly) but I can't find any data in the source cube.
In the data-source sheet I can see in the preview area the first line of the source-data. So the view is available. I also added an ASCIIOutput statement in the data section, but the process does't create the logfile... I also changed the name of the targetcube in the CellPutN statement to a cube which does't exists. But I don't get an error durring the process. Seems like the statements doesn't get executed a single time...
I really hope that I'm just confused because it's monday and this isn't a serious problem...
TI-Process Date load from other cube
-
qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: TI-Process Date load from other cube
This suggests that the Data tab doesn't get executed because the source view is empty. Try looking at view parameters: zero suppression, rule suppression, consolidation suppression and adjust accordingly.maps wrote:I also added an ASCIIOutput statement in the data section, but the process does't create the logfile
Kamil Arendt
-
Michel Zijlema
- Site Admin
- Posts: 713
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: TI-Process Date load from other cube
It sounds like your source view definition is not correct, i.e. not selecting any data...
You could right-click your source view object in Server Explorer and select 'Export as Text data' from the shortcut menu. This will open up the cube view editor. From here you can check all selections on all dimensions and check the 'skips' that are (not) set. You could also run the export from here to check whether this will generate any output.
Things to check:
Is the structure of the source and data cube identical, or are there differences in the number of dimensions and or granularity of the dimensions? If the source view contains consolidated elements and the 'Skip Consolidated Values' is checked all values will be skipped... If all values in the source view are rule-calculated and the 'Skip Rule Calculated Values' is checked all values will be skipped...
HTH, Michel
You could right-click your source view object in Server Explorer and select 'Export as Text data' from the shortcut menu. This will open up the cube view editor. From here you can check all selections on all dimensions and check the 'skips' that are (not) set. You could also run the export from here to check whether this will generate any output.
Things to check:
Is the structure of the source and data cube identical, or are there differences in the number of dimensions and or granularity of the dimensions? If the source view contains consolidated elements and the 'Skip Consolidated Values' is checked all values will be skipped... If all values in the source view are rule-calculated and the 'Skip Rule Calculated Values' is checked all values will be skipped...
HTH, Michel