I have a Cube in which I load Forecast from a external source. On the first load all the figures came out correct. But when Forecast numbers changed to Zero in the source system then this Zero is not getting updated in TM1.
Please see the example in the attached screen shot. Value of Orange was 5 in the initial load and when it was changed to Zero then the Cube does not update this. I have marked these wrong numbers in RED in the attachment.
Can someone please advise me whats the reason? Do I have to ZeroOut the cube each time the cube loads the data?
I am on TM1 9.1 SP3. Is that a version issue?
Revised Forecast not showing correctly in Cube
-
- Posts: 103
- Joined: Mon Sep 21, 2009 7:09 pm
- OLAP Product: Cognos Tm1
- Version: 10.2.2
- Excel Version: 2016
Revised Forecast not showing correctly in Cube
- Attachments
-
- Cube update issue
- CubeUpdateIssue.jpg (45.35 KiB) Viewed 1821 times
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Revised Forecast not showing correctly in Cube
No it's not a version issue. Yes, you do have to explicitly zero out preexisting values unless the feed from your source system explicitly contains zeroes, which most don't given the number of zero values that would need to be contained in the feed.ExApplix wrote:I have a Cube in which I load Forecast from a external source. On the first load all the figures came out correct. But when Forecast numbers changed to Zero in the source system then this Zero is not getting updated in TM1.
Please see the example in the attached screen shot. Value of Orange was 5 in the initial load and when it was changed to Zero then the Cube does not update this. I have marked these wrong numbers in RED in the attachment.
Can someone please advise me whats the reason? Do I have to ZeroOut the cube each time the cube loads the data?
I am on TM1 9.1 SP3. Is that a version issue?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.