TM1 Forum

Thanks a lot for all these suggestions, I will try to look in to them and see how it goes.

Hi , I have a cube with 5 years of sales data at day level . I have a rule to calculate Revenue Per day at Month level(C) . I have the below rule and feeder . I extract flat files from tm1 to asciioutput for few measures and when i do it for this rule based measure it takes a lot of time to extract ...

I have a month number alias on months element. so for example, for Jun 2021 my alias is 202112 (fiscalyearno) I can get the currnt months alias which is 202112 then get the year part and subtract with 2. SO now i would form 201912 - which will be jun 2019 . Now I need everymonths from Jun 2019 to Ju...

HI , I wanted to extract a flat file from tm1 on a daily basis that would extract 2 years of data. I have to create a subset dynamically that would give the n level for 2 years of date. My time dimension is in this format : Year -2021 Month - Jun 2021 Date - 20210609 So i want a subset having all va...

Hi Wim , I am creating a zz_view in the prolog and assigning to the datasource .I was confused where something has to be initally set on the datasourc tab to the process een we overwrite that on the prolog with a view. So I get that the order of the view now created will be based on dimension order ...

Hi , If we dont use a view that we created , in my data source tab what should i pick from the cube as cube view ? In my prolog , I create a view and assign values to dimension and assign it to the view , does this view gets created with the dimension in order of the cube and can it link back to my ...

I think i got it ,
I have to destroy the subset and then use subssetcreatemdx .
Which one is better if i have to just use for zerout .
subsetcreatebymdx or SUBSETMDXSET

Hi , I am trying to create a subsetcreatebymdx with below code vMdx= '{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Price Range] )}, 0)}'; SubsetcreatebyMdx(subsetname,vmdx,0); But its giving me an error unable to register the subset . I want to use it for zero out in prolog . But then I did a similar SUBSETMD...

One more question , I am using this to do a extract from tm1 . I am creating a view where it has some dimensions with consolidated elements. So I dont want my consilidations on some dimension to be extracted , so its better if i do only n elements on those right. By default i have a cube view as my ...

Hi ,

I am doing a zerout on a view in prolog .

For few dimensions i want to zero out all n elements , should i create a subset with all n elements for these dimensions ?

if so should i do a mdx with all n elements ?

Thanks,

HI, I am having this error in error log. [Microsoft][ODBC Driver Manager] Cursor library not used. Load failed Tried to run a ti with a sql on it , Sql is pretty simple and returns only few rows , the issue happens when i dont save the ti process and just try to go to variable table after previewing...

Hi, I have a master product diemnsion which has 20000 items in it . I am having a sales cube that uses that dimension. I am planning to do a look up on this dimension on whicheve item has sales to add it to a new dimension , . Should i have my dimension insert on meta data of the sales cube laod pro...

Hi , I am using a sql statement in my ti. I have begin and End and the sql inbetween , which does a union Begin Sql command End It works fine ,but suddenly 1 or 2 days later the sql has only first 3 to 4 lines and rest gets cut and causes sql failed. Then i will hae to recopy the sql and then resave...

I will try optimisepy but I also wanted to try to calculate manually for one time, I came down to 3 dimensions. Custoemr has - 30000 customers. i did customers on rows with n and then all other dimension as Total and measure as sales. So there were 19500 customers having value. so is my density - 19...

I looked at the link , So for my example I have a few dimensions which i wanted to ask your thoughts . First question is the last dimension on the cube should be a Measure or can measure be in any place. I am in a assumption Measure should be the last. Rank/Sort the dimensions by density then by siz...

Hi , Just wanted to provide an update on this .I did a reorder in perspective but did my own order based on your comments . I picked all dense elements like time period , customers etc and moved towards the end in order , the memory which was in 38 gb came around to 18 gb when i deleted the cube ad ...

Hi , I am using a sql view in my ti to load data , in my sql view I have SID' stored in numeric columns , so in my ti I am just changing them to string from numeric . Will tm1 internally convert to string when we say string in the variable tab . I am asking becasue should i do this conversion in the...

Hi TM1 Users, I have been using a sales cube with month level detail for few years and performace has been okay . Now I have added few dimensions to the cube and made it day level . I dont have any complex rules , just loading data from Data warehouse. On Cube memory usage it showw 40 gb memory been...

Hi Tm1 Users, which I have the below sales cube with following dimensions. TImeperiod - Year -> Month->Date Customer Products Sales Measures Business Day ( Has days from 1 to 23 ) I am having a time period dimension which can track sales by calendar days , business requested to have a business day d...

Thanks a lot Adam for taking time to give some references and for being so supportive. I will look in to them one by one and start practising. Yes the members on this forum has been very supportive and i wanted to do some homework before getting to them in case of any issues.