Search found 12 matches

by howard40116
Fri Nov 25, 2022 2:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Order By not applying to last member in dimension
Replies: 5
Views: 1549

Re: MDX Order By not applying to last member in dimension

You can try this MDX query.

Code: Select all


{ORDER(
    {TM1FILTERBYLEVEL(
		{TM1SUBSETALL( [Month] )}
	,0)}
, [Month].[Seq No], ASC)}

by howard40116
Thu Oct 07, 2021 1:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to decrypt the cell which CubeSetConnParams fill in?
Replies: 2
Views: 2785

Re: How to decrypt the cell which CubeSetConnParams fill in?

CubeSetConnDatabase is used to set a password specific for connecting to your tm1 cube. TM1 databases are already encrypted (if usessl=T is set on the model) so as long as you ensure no one has read/write access to the cube no one except admin users can access the passwords you've stored in the cub...
by howard40116
Wed Oct 06, 2021 6:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to decrypt the cell which CubeSetConnParams fill in?
Replies: 2
Views: 2785

How to decrypt the cell which CubeSetConnParams fill in?

We have multiple data source from ODBC , therefore we create the parameter cube to record the password. But for the new policy need to encrypt password. Now , we try to use function CubeSetConnParams encrypt the password ,but in the next step we don't konw how to decrypt it. Anyone knows how to decr...
by howard40116
Tue Nov 24, 2020 5:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: zerout view
Replies: 3
Views: 1429

Re: zerout view

1.you can try to paste your mdx in the subset selector, validate your mdx is correct. 2.you can try to destroy your temporary subset or use subsetMDXSet. #1.SubsetDestroy vDimension='Invoiced Partners'; vSourceSubset=vDimension| ' All N'; vMdx= '{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Invoiced Partners] ...
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: 2197

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: 2575

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:// &q...
by howard40116
Wed Nov 06, 2019 7:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock codes
Replies: 5
Views: 3836

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: 7498

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 principa...
by howard40116
Fri Nov 01, 2019 1:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Alias
Replies: 7
Views: 7498

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 "C...
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: 4710

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: 1845

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: 3898

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