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