Average number of days
-
appleglaze28
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
Average number of days
I'd like to ask if anybody knows how to average days base on the number of element in a specified dimension. This dimension would be dynamic so, i there anyway best practice on this that you can share?
-
Alan Kirk
- Site Admin
- Posts: 6644
- 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: Average number of days
I think that you may need to rephrase the question. What exactly does the dimension represent? What values are being used to calculate an average; average days per what?appleglaze28 wrote:I'd like to ask if anybody knows how to average days base on the number of element in a specified dimension. This dimension would be dynamic so, i there anyway best practice on this that you can share?
(It may be best to give a description of the cube(s) involved and the dimensions that they contain, and what you want to calculate.)
"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.
-
Jeroen Eynikel
- Community Contributor
- Posts: 139
- Joined: Mon Sep 15, 2008 1:45 pm
Re: Average number of days
Elcomp (or was it elcompn) returns you the number of children for a consolidated element. If I understand your question correctly that should be the answer for you.appleglaze28 wrote:I'd like to ask if anybody knows how to average days base on the number of element in a specified dimension. This dimension would be dynamic so, i there anyway best practice on this that you can share?
-
Martin Ryan
- Site Admin
- Posts: 1989
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: Average number of days
There is some discussion about averages in this post: http://forums.olapforums.com/viewtopic.php?f=21&t=388, which may help.
Martin
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer
Re: Average number of days
Are you asking the average number of days for a particular element in the cube or for all the elments in the cube.