Search found 8 matches

by howard40116
Wed Jul 08, 2020 7:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adobe Flash Player phase out issue
Replies: 3
Views: 156

Adobe Flash Player phase out issue

Everyone knows Adobe Flash Player will no longer be supported in 2021.

Does it affect TM1 system :?:

I can't find any information in IBM's Official website.
by howard40116
Wed May 06, 2020 2:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Buttons - Navigation in Perspectives v Web
Replies: 3
Views: 623

Re: Action Buttons - Navigation in Perspectives v Web

Maybe you can use Excel Function https://support.office.com/en-us/article/hyperlink-function-333c7ce6-c5ae-4164-9c47-7de9b76f577f #Syntax Hyperlink(link,friendly_name) #Example Excel Cell:$A$1 Name:pFile =DBRW(...) Excel Cell: $A$2 Name:pServer =DBRW(...) Excel Cell: $A$3 Name:plink ="TM1:// "& pSer...
by howard40116
Wed Nov 06, 2019 7:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock codes
Replies: 5
Views: 1740

Re: Bedrock codes

You can download the newest Bedrock in Cubewise's Github

Bedrock3
https://github.com/cubewise-code/bedroc ... v3-archive

Bedrock4
https://github.com/cubewise-code/bedrock
by howard40116
Mon Nov 04, 2019 6:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Alias
Replies: 7
Views: 4216

Re: Tm1 Alias

A new Bedrock process might be born 😉 Actually I think there might be one already! We already have one in the "consultant toolkit" that basically does exactly this; find blank cells for alias attributes (and Caption regardless whether defined as String or Alias) and populate with principal name. En...
by howard40116
Fri Nov 01, 2019 1:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Alias
Replies: 7
Views: 4216

Re: Tm1 Alias

##Reminder When the alias is the same as the principle element name You can go to the attribute viewer and the alias column will display the same name as the principle element. But when you open attribute Cube today, you will find that the cell is blank. So when you use "ATTRS" and "CELLGET", only t...
by howard40116
Fri Sep 20, 2019 1:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple Cubes vs One Cube
Replies: 5
Views: 2608

Re: Multiple Cubes vs One Cube

Maybe you can create the element Month : No Month Day: No Day In this case , user can easy to know why [Product Cost] and [Product Tax] have only one amount in a year. ['Sale Cost'] = DB('Sales', !Company Branch, !Year, 'No Month', 'No Day', 'Actual', !Products,'Product Cost') * ['Unit Sold']; ['Tax...
by howard40116
Fri Jul 05, 2019 8:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: forecasting
Replies: 2
Views: 518

Re: forecasting

you can refer to the tm1's sample instance.

:arrow: :arrow: :arrow:
https://www.ibm.com/support/knowledgece ... mples.html
by howard40116
Mon Dec 24, 2018 7:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subsets on Time dimension
Replies: 5
Views: 1918

Re: Dynamic subsets on Time dimension

1.Create Parameter Cube(Dim:Parameter{Timestart,TimeEnd},Measure:Measure) 2.Fill in Timestart and TimeEnd 3.Use this MDXQuery to create MDXSubset 4.Finally , you can use cell to control this Dynamic subsets MDXQuery: { StrToMember("[Time].[" +[Parameter].([Parameter].[Timestart],[Measure].[String])+...