Please read this ,It might be of help
http://www.ibm.com/support/knowledgecen ... 00123.html
https://everanalytics.wordpress.com/201 ... ognos-tm1/ Thanks
Search found 423 matches
- Wed Sep 28, 2016 5:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Filtering on Dimensions
- Replies: 4
- Views: 3283
- Wed Sep 28, 2016 4:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Is DimensionSortOrder only valid in Metadata?
- Replies: 3
- Views: 2307
Re: Is DimensionSortOrder only valid in Metadata?
Undertandably,Metadata changes wouldn't work when it get passed metadata tab.You have to either place it in prolog or metadat tab to get it work.Thanks
- Thu Sep 22, 2016 10:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy data from one element to another element in a single dimension
- Replies: 7
- Views: 4648
Re: Copy data from one element to another element in a single dimension
Hi Arvind,Please have a look at below link,It gives you good idea of expand function usage.
http://users.skynet.be/fa436118/wim/tm1 ... tII_EN.htm Thanks
http://users.skynet.be/fa436118/wim/tm1 ... tII_EN.htm Thanks
- Tue Sep 06, 2016 4:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Check Content Store database version
- Replies: 2
- Views: 3682
Re: Check Content Store database version
This might help.Please have a look:
http://www-01.ibm.com/support/docview.w ... wg21660204
CMSYSPROPS :This table has the Content Store Version
Thanks
http://www-01.ibm.com/support/docview.w ... wg21660204
CMSYSPROPS :This table has the Content Store Version
Thanks
- Mon Aug 29, 2016 2:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy sort and Hierarchy MDX
- Replies: 24
- Views: 14315
Re: Hierarchy sort and Hierarchy MDX
Thanks Wim ,Very useful.
- Fri Aug 26, 2016 1:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ConsolidatedAvg with several dimensions
- Replies: 2
- Views: 2739
Re: ConsolidatedAvg with several dimensions
Hi ygrodrig6,How did you go by going through Duncan P suggestion? Thanks
- Thu Aug 25, 2016 8:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to build an Active form with two different views
- Replies: 1
- Views: 1469
Re: How to build an Active form with two different views
Please go through below two links:
http://www-01.ibm.com/support/docview.w ... 1665&aid=1
http://www.ibm.com/support/knowledgecen ... 80007.html Thanks
http://www-01.ibm.com/support/docview.w ... 1665&aid=1
http://www.ibm.com/support/knowledgecen ... 80007.html Thanks
- Tue Aug 16, 2016 2:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bring data from one cube to another when they have different dimension structure
- Replies: 19
- Views: 10934
Re: Bring data from one cube to another when they have different dimension structure
Hi ViRa,Unless you post screenshot of exact dimensionality and your requirements bit clear manner,it wouldn't lead to anywhere and rather waste valuable time of people who are trying to help you out here. Yes, Model and Risk Types are dimensions as well as measures in Cube B. statement such as above...
- Mon Aug 15, 2016 3:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Break back in TM1 at consolidated level
- Replies: 5
- Views: 3618
Re: Break back in TM1 at consolidated level
Hi Nidhi,You could also find this thread useful:
http://www.tm1forum.com/viewtopic.php?f ... Rules#p468 Thanks
http://www.tm1forum.com/viewtopic.php?f ... Rules#p468 Thanks
- Tue Aug 09, 2016 7:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Want to Know Use of DIMNM & DIMIX Function ?
- Replies: 6
- Views: 3597
Re: Want to Know Use of DIMNM & DIMIX Function ?
You could also look at the Chapter 7. Rules for Time-Based Calculations in the TM1 rules guide,It explains well using of Diimix and DName.Thanks
- Tue Aug 02, 2016 3:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SwapAliasWithPrincipalName
- Replies: 6
- Views: 8131
Re: SwapAliasWithPrincipalName
SwapAliasWithPrincipalName is known to have some issues and wouldn't be trusted fully. Couldn't you export the data and do the necessary changes and import it back.Of course data backup is mandatory.It far more reliable and easier.Thanks.
- Wed Jul 20, 2016 9:11 am
- Forum: Cognos Planning and BI
- Topic: Join problem in FM
- Replies: 4
- Views: 59732
Re: Join problem in FM
Hi tm1fmuser,Although name may sound bit similar this is not Cognos Forum rather it is Cognos TM1 Forum. Please post your query in Cognoise forum under Framework Manager section: http://www.cognoise.com/ https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000...
- Fri Jul 15, 2016 7:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: All Dimensions in Cell Security
- Replies: 3
- Views: 2135
Re: All Dimensions in Cell Security
Bit more info on the CellSecurityCubeCreate in the below thread:
http://www.tm1forum.com/viewtopic.php?t=3510 Thanks
http://www.tm1forum.com/viewtopic.php?t=3510 Thanks
- Fri Jul 15, 2016 4:03 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 10.2.2 FP6
- Replies: 57
- Views: 44254
Re: TM1 10.2.2 FP6
I am interested to know more about CubeDimensionCountGet ,It seems the link is broken.Could find anything on google either.Thanks.
- Wed Jul 13, 2016 3:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CellSecurity Cube question
- Replies: 10
- Views: 6211
Re: CellSecurity Cube question
Did you look at below post:
http://www.tm1forum.com/viewtopic.php?f=3&t=12623 Thanks
http://www.tm1forum.com/viewtopic.php?f=3&t=12623 Thanks
- Tue Jul 12, 2016 8:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Link to PDF in tm1web
- Replies: 3
- Views: 2775
Re: Link to PDF in tm1web
You can display a link to a pdf document in TM1Web as per below IBM doc,If I am understand correctly what you are after:
http://www-01.ibm.com/support/docview.w ... wg21454744 Thanks
http://www-01.ibm.com/support/docview.w ... wg21454744 Thanks
- Thu Jul 07, 2016 5:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Feeders - Rule is nested If's and Source Cube is a Control Cube.
- Replies: 27
- Views: 14711
Re: TM1 Feeders - Rule is nested If's and Source Cube is a Control Cube.
There are at least two. I may find more uses as I begin actual development using TM1: First as an alias, which is one type of attribute. I think the purpose of an alias attribute is obvious. If not, there is a lot of information out there that would provide you with information regarding an alias a...
- Thu Jul 07, 2016 12:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: All Parents for n level element
- Replies: 4
- Views: 3671
Re: All Parents for n level element
For that matter ,ELPARN is much more relevant to OP and this is what you could see in Wim Gielis post I have shared above ;
Thanks
Code: Select all
ELPARN returns the number of parents of an element in a specified dimension.
Syntax
ELPARN(dimension, element)
- Thu Jul 07, 2016 10:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: All Parents for n level element
- Replies: 4
- Views: 3671
Re: All Parents for n level element
This might help:
http://users.skynet.be/fa436118/wim/tm1 ... ing_EN.htm Thanks
http://users.skynet.be/fa436118/wim/tm1 ... ing_EN.htm Thanks
- Thu Jul 07, 2016 10:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Feeders - Rule is nested If's and Source Cube is a Control Cube.
- Replies: 27
- Views: 14711
Re: TM1 Feeders - Rule is nested If's and Source Cube is a Control Cube.
I have one question though,Sorry for my ignorance,If you intend to go with your actual design How does would it be helpful to you in TM1 reporting and what is the point of having key elements as attributes which wouldn't consolidate ?Thanks