Search found 26 matches
- Wed May 16, 2018 12:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: show recently added elements in subset.
- Replies: 5
- Views: 3805
Re: show recently added elements in subset.
Why don't you add an attribute to the dimension and use it for Filtering or SOrting? You cannot rely on the Element Index since it changes How attribute will identify the new element? it is not necessary in source data that new elements will come at last if i assign attribute as incremental numbers...
- Wed May 16, 2018 12:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: show recently added elements in subset.
- Replies: 5
- Views: 3805
Re: show recently added elements in subset.
Why don't you add an attribute to the dimension and use it for Filtering or SOrting? You cannot rely on the Element Index since it changes How attribute will identify the new element? it is not necessary in source data that new elements will come at last if i assign attribute as incremental numbers...
- Wed May 16, 2018 12:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: show recently added elements in subset.
- Replies: 5
- Views: 3805
show recently added elements in subset.
Hi All , i have dimension which have elements lets say 1 2 3. Now after load 2 more elements is added 1 2 3 4 5 Now in a worksheet i want to show only those recently added elements.how can i achieve this? i have tried with index sort like {Subset ( {TM1FILTERBYLEVEL( {TM1SORTBYINDEX( {TM1SUBSETALL( ...
- Mon Dec 11, 2017 10:55 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW questions
- Replies: 8
- Views: 5887
Re: PAW questions
Hi members, i have downloaded and installed Planning Analytics 2.0 but i was unable to locate Planning analytics work space(PAW) in it. its looks like TM1 10.2 version for me with Architect,performance modeler and insight application.where i can locate PAW? is there any other software i need to inst...
- Fri Sep 22, 2017 1:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)
- Replies: 5
- Views: 4525
Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)
Thanks guys for reply.yes you guys are right there were more than one consolidation in my dimension which was causing this issue i corrected it and everything is fine.
- Thu Sep 21, 2017 4:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)
- Replies: 5
- Views: 4525
Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report
Tried RefreshMdxHierarchy('') but it did not work for me.jim wood wrote: ↑Wed Sep 20, 2017 1:43 pm You might want to look at this:
http://www.tm1forum.com/viewtopic.php?f ... 887#p66832
- Wed Sep 20, 2017 12:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)
- Replies: 5
- Views: 4525
Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)
Hi All,
My TM1 Cube is used in a Cognos report. i am pulling a leaf level data from TM1 to Cognos report. suddenly one of my dimension showing up unwanted concatenated hierarchy for most of elements instead of leaf level element. Can anyone tell what should be the issue?
My TM1 Cube is used in a Cognos report. i am pulling a leaf level data from TM1 to Cognos report. suddenly one of my dimension showing up unwanted concatenated hierarchy for most of elements instead of leaf level element. Can anyone tell what should be the issue?
- Mon Apr 24, 2017 11:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Load Data in TM1 Cube from CSV
- Replies: 4
- Views: 4291
Re: Load Data in TM1 Cube from CSV
Just create a "sample" file, that has all 24 months in it, and use that to create your code. You can leave the column names as you have them as the variable names (put a "v" in front as TM1 doesn't like numeric only variable names). Then you write 24 CellPutN statements in the D...
- Mon Apr 24, 2017 10:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Load Data in TM1 Cube from CSV
- Replies: 4
- Views: 4291
Load Data in TM1 Cube from CSV
Hi Experts, i am having data in following format. Capture1.JPG the columns in yyyymm format is measure i.e. employee working hours. these columns are dynamic means data is available for 8,9,12 up-to 24 month. my cube have following dimension Employee,Project,Month,Measure dimension(hours) because of...
- Mon Jun 27, 2016 10:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Security Not working when publishing Application using performance modeler.(Solved)
- Replies: 5
- Views: 5248
Re: TM1 Security Not working when publishing Application using performance modeler.(Solved)
Hi All, This issue was because of new group "CAMID("::Everyone")" Added when I am creating an application by Performance modeler. Finally I am able to solve this. the new group should have READ permission in Cubes security and dimension security by default it has no security assi...
- Wed Jun 22, 2016 1:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Security Not working when publishing Application using performance modeler.(Solved)
- Replies: 5
- Views: 5248
Re: TM1 Security Not working when publishing Application using performance modeler.
If you use integratedseuritymode=5, there must not be }tp_everyone group. There can be CAMID("::Everyone") for 5, or }tp_everyone for 1. The process "}tp_application_deploy" should delete the "}tp_everyone" group when you deployed your application: If (vSecurityMode @=...
- Tue Jun 21, 2016 11:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Security Not working when publishing Application using performance modeler.(Solved)
- Replies: 5
- Views: 5248
TM1 Security Not working when publishing Application using performance modeler.(Solved)
Hi TM1 Experts, We are using TM1 10.1.1 with Cognos BI workspaces, with Migration of TM1 10.2.2 , Cognos BI workspaces no longer works with TM1 properly. So IBM asked to switch to the Applications published using performance modeler. Now my Problem with Performance modeler. I copied everything in Da...
- Fri Jan 08, 2016 12:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error in MDX
- Replies: 1
- Views: 2408
Error in MDX
Hi All, I am trying to create a MDX for my subset, when use Record Expression functionality in subset editor is this MDX works fine. {FILTER( {TM1SUBSETALL( [MY Dimension] )}, [MY Dimension].[ORI] = "ORI")} Here ORI is my Attribute. When Same MDX i paste it in subset editor expression wind...
- Mon Dec 14, 2015 10:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Move data from one group to another group in an organization dimension
- Replies: 11
- Views: 5852
Re: Move data from one group to another group in an organization dimension
Use this code in your existing code Delete all the consolidated element in your dimesnion first . code in prolog would something like this nSize = DIMSIZ( Dim_Name ); nCount = 1; While( nCount <= nSize ); sMem = DIMNM( Dim_Name, nCount); If( DTYPE( Dim_Name, sMem ) @= 'C' ); DimensionElementDelete( ...
- Fri Oct 30, 2015 7:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: [SOLVED] What is TurboIntegrator function to assign Measure Dimension cube property to cube?
- Replies: 3
- Views: 2893
Re: What is TurboIntegrator function to assign Measure Dimension cube property to cube?
why cant you assign value in }CubeProperties using cellputs('Dimension name', '}CubeProperties','Cube name','Measures Dimesnion') in your TI code?
- Tue Oct 20, 2015 1:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to find subsets used in TM1 View
- Replies: 4
- Views: 5843
Re: How to find subsets used in TM1 View
open views VUE file in TI as text source, you will find two column text file, than whatever the value of column second with column one value "6" is subset used in your view.column one value "7" is all dimension used. hope this will answer your query.
- Wed Oct 14, 2015 1:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Database credentials in TI
- Replies: 18
- Views: 11688
Re: Database credentials in TI
Now for a last requirement I need suggestion from gurus, My client want to develop a front end page by which an admin can input database credentials in form of password type (********), I tried with view and web sheets but it didn’t work out, I haven’t tried TM1 API way and try to avoid it as we ar...
- Wed Oct 14, 2015 1:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Database credentials in TI
- Replies: 18
- Views: 11688
Re: Database credentials in TI
Thank All , for your generous help, i was able to achieve what i wanted , the last mistake I was doing is because of SQL beautifier, As TM1 engine was not able to understand some statement and merging some text like select col1from... etc. , I removed all the unnecessary spaces in my sql statements ...
- Mon Sep 28, 2015 6:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutPut Data Export
- Replies: 4
- Views: 3769
Re: ODBCOutPut Data Export
are you excuting odbcoutput for delete in matadata or data tab? it should be prolog or in epilog..
- Fri Sep 25, 2015 6:43 am
- Forum: Cognos Planning and BI
- Topic: Showing full name with email address in scheduled Cognos Report
- Replies: 0
- Views: 39232
Showing full name with email address in scheduled Cognos Report
Hi, When we scheduled a report and select the option "send by email”, Report is delivered to our inbox with full email address instead of its name, for example if I schedule a report it will come to my inbox with email address AB_CD@Mail.com , our user wants to see name instead of email address...