Hi can any one please confirm if we can work on commentary with contributor.
My requirement is user want to enter a comment for each month sales and submit that comment to manager and manager has to approve it to appear in the cube. Is this requirement really possible, cuz we use approval hierarchy, but string element will not aggregate to consolidated level.
commentary in contributor
- rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: commentary in contributor
Yes you can aggregate a String in a consolidation level.
In your Measures dimension, you can create an String element. Users can then enter the comments under this string element.
In your Measures dimension, you can create an String element. Users can then enter the comments under this string element.
Cheers!
Rizwan Kaif
Rizwan Kaif
-
- Posts: 49
- Joined: Fri May 28, 2010 4:47 am
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2003
- Location: IL, USA
Re: commentary in contributor
I did same thing, but when ever level1 employee enters a comment and submits it, next when manager at level 0 opens the contributor he s not able to see comments as string is not consolidating and aggregating to level0.
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: commentary in contributor
A reviewer should be able to see detail underneath the review level. What you are saying is that you want the detail comments concatenated together into one summary cell as users hit the submit button? Cant a reviewer simply browswe through the detail to see the comments?
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: commentary in contributor
I'm not really sure about the OP's requirement or this comment ...
I agree with PlanningDev, the approval manager should browse the submitted commentary from the levels below.
By definition strings don't consolidate. A string can be entered in any cell of a cube, consolidated or not. If you really wanted you could define a rule to concatenate the strings together from children of a consolidation (maybe this is what rkaif meant?) but this could be restrictive, often you may need a separate comment at a higher level.rkaif wrote:Yes you can aggregate a String in a consolidation level.
I agree with PlanningDev, the approval manager should browse the submitted commentary from the levels below.
- rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: commentary in contributor
Sorry it was a typo in my previous post. Thanks lotsaram to noticing this.lotsaram wrote:By definition strings don't consolidate.
Cheers!
Rizwan Kaif
Rizwan Kaif