Search found 26 matches

by escape18in
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: 3681

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...
by escape18in
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: 3681

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...
by escape18in
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: 3681

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( ...
by escape18in
Mon Dec 11, 2017 10:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW questions
Replies: 8
Views: 5655

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...
by escape18in
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: 4405

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.
by escape18in
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: 4405

Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report

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
Tried RefreshMdxHierarchy('') but it did not work for me.
by escape18in
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: 4405

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?
by escape18in
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: 4225

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...
by escape18in
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: 4225

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...
by escape18in
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: 5210

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...
by escape18in
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: 5210

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 @=...
by escape18in
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: 5210

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...
by escape18in
Fri Jan 08, 2016 12:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error in MDX
Replies: 1
Views: 2389

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...
by escape18in
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: 5825

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( ...
by escape18in
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: 2868

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?
by escape18in
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: 5788

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.
by escape18in
Wed Oct 14, 2015 1:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Database credentials in TI
Replies: 18
Views: 11586

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...
by escape18in
Wed Oct 14, 2015 1:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Database credentials in TI
Replies: 18
Views: 11586

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 ...
by escape18in
Mon Sep 28, 2015 6:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutPut Data Export
Replies: 4
Views: 3743

Re: ODBCOutPut Data Export

are you excuting odbcoutput for delete in matadata or data tab? it should be prolog or in epilog..
by escape18in
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: 38000

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...