Not Fed issue

Post Reply
Mithun.Mistry1103
Posts: 40
Joined: Thu Jul 03, 2014 1:14 pm
OLAP Product: cognos
Version: 10.2
Excel Version: 2010

Not Fed issue

Post by Mithun.Mistry1103 » Wed Sep 13, 2017 9:41 pm

Hello all.

I was suppose to relax and watch football but instead thinking about intersections that are not fed. So I have two cubes, one which is the data cube, second which is analysis cube.

Previously I had used a TI that allowed me to input numeric values against any periods that were between start and end date. That worked smoothly. And I was thinking I may as well just use that mechanism again for a similar analysis but then thought of trying the rule method. Now with that method, when I suppress zeros, I am losing all but 2 of my numeric analysis thats between the two trimmed dates but the number against the start date and end date stay as they are fed. How do I make it so that all the numbers between the dates also stay and are fed? So when I suppress zeros, Il have those numbers.

Thank you in advanced :)

User avatar
PavoGa
Community Contributor
Posts: 151
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 fixpack 2 & 7
Excel Version: 2013
Location: Cleveland, Tennessee

Re: Not Fed issue

Post by PavoGa » Thu Sep 14, 2017 9:41 pm

Need more information on the structure of your cubes and, particularly, the period dimension referred to in your message.
Ty
Cleveland, TN

Mithun.Mistry1103
Posts: 40
Joined: Thu Jul 03, 2014 1:14 pm
OLAP Product: cognos
Version: 10.2
Excel Version: 2010

Re: Not Fed issue

Post by Mithun.Mistry1103 » Fri Sep 15, 2017 2:49 am

PavoGa,

If you refer to my previous post, it would give you an idea of what I did last time and I have replicated the situation, the only thing I am doing this time round is instead of taking the easy way out and doing whats already been a success the TI way, I want to do something different which is do the rule way. With TI's, your able to feed a number in, whereas doing it as rule means I am going to some how feed to ensure when we suppress zeros, it doesnt get rid of the 1's.

http://www.tm1forum.com/viewtopic.php?f=3&t=13416

Thank you Sir.

Wim Gielis
MVP
Posts: 1514
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Not Fed issue

Post by Wim Gielis » Fri Sep 15, 2017 6:23 am

Please have a look at the other topic yourself.
There are already feeders in there, by JulianS.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 103 TM1 articles and a lot of custom code
Newest blog article: TM1 message log analysis with Power Query

Mithun.Mistry1103
Posts: 40
Joined: Thu Jul 03, 2014 1:14 pm
OLAP Product: cognos
Version: 10.2
Excel Version: 2010

Re: Not Fed issue

Post by Mithun.Mistry1103 » Fri Sep 15, 2017 1:03 pm

Hey Sir.

I have used his rules and feeders as a start of a ten, but the issue is it feeds the start date and end dates, but not the periods in between. Ultimately, they have the numeric but when I suppress zero, it only keeps the start date and end date.

Thanks

declanr
MVP
Posts: 1537
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Not Fed issue

Post by declanr » Fri Sep 15, 2017 2:06 pm

Is your next period attribute populated correctly? Try clicking trace feeders to see if the value is being pushed to the next month and then you should see where it fails.

If you provide your full rules sheet/s it should help people to analyse it for you.

Mithun.Mistry1103
Posts: 40
Joined: Thu Jul 03, 2014 1:14 pm
OLAP Product: cognos
Version: 10.2
Excel Version: 2010

Re: Not Fed issue

Post by Mithun.Mistry1103 » Fri Sep 15, 2017 6:13 pm

Heyy Declan, the next periods and the previous periods are all fine. I shall post the rules on Monday, in meantime, i will try creating a demo version and see if I can sort this issue. I have tried to trace the feeders and compared them to the start period that is fed to see the difference. Nothing obvious so il see if I can break down the issue on the demo I create. I did have in mind what you had said about the issues that may rise before I took up the rule method.

Thanks alot Sir.

Post Reply