TM1 Forum

Thanks much, Burnstripe.

This Document is very helpful to be sure of something is not possible rather than keep digging to figure it out .

Thanks.

Hi all,

We know that a workbook in PAW can be exported and shared over an email.
But is it possible to schedule it meaning to get it delivered to an email every day at a specific time ?

Appreciate any guidance here.

Thanks.

Thank you so much BurnStripe and Wim.

Wim, I didn't know that you have a Webpage. It's really helpful.

Hi all, I am trying to create a source view within a TI process using MDX to filter based on Cube value. So, the cube has 7 dimensions and I have created the source view based on the requirement as below which works fine Dim1 - 1 Static element selected Dim2 - 3 Consolidated elements selected Dim3 -...

Thank you all. Sorry for the late reply.
Yes , both options work.
Thanks again George ,Wim and Lotsaram

I don't think you really understood the concept of using Expand here. You EITHER use expand to build the whole string converting variable names to their value by wrapping with % OR you use the pipe symbol to do the concatenation. You don't use pipes within the Expand, because what is there is just ...

Thank you to both of you. - Lotsaram and gtonkin I will try to put the Hierarchy kinda MDX also which Lotsaram mentioned . This one Worked . vMDX= Expand('{TM1FILTERBYPATTERN( {Descendants( [' | dimName | '].[Total] ) } , "*%pAccount%*" )}'); But, These did not work (did not render any ele...

You need to assign the whole MDX statement to a string variable e.g. sMDX='{TM1FILTERBYPATTERN( {TM1FILTERBYLEVEL( {Descendants( [ Account].[Total] ) } , 0)}, "* ' | pAccount | ' *" )}'; You could also try reduce the complexity of the quotes by using the Expand() function: sMDX=Expand('{T...

Here you can use Expand to generate a string which contains double quotes. TM1FILTERBYPATTERN also has an argument for the attribute to search in. Otherwise you will be searching the principal name. The Descendants function can already return only leaves so no need to wrap in FilterByLevel. Even th...

Hi experts, I have simple MDX to be filtered by a wildcard which needs to be parameterized within a process. The result should be as below where we are filtering by level zero for consolidation 'Total' and then doing a wildcard search for 'GL' in those elements. {TM1FILTERBYPATTERN( {TM1FILTERBYLEVE...

source has numbers -> ran the process -> data got loaded into the cube Source deleted some numbers -> ran the process -> will it replace the existing numbers with a zero in those target cells. This will depend. If the numbers deleted from the source are represented in the query as records containin...

Yes typically you do a zero out such that combinations that had values previously, but not at the time of a new load, are empty/do not exist anymore/do not take up space anymore. A process without zero out is possible too, but are less frequent. It depends on the use case. Thank you, Wim Gielis :)

Hi all, I have 2 questions: 1) Do we really need a zerout to be done in the TI process while using CellPutN for data load since it replaces the existing numbers? 2) If data is being pulled via SQL and we have used CellputN for load into the cube. source has numbers -> ran the process -> data got loa...