TM1 Forum

Hi Guys, I am facing a problem which I would like to check this with the experts here. I have dimension name Project which uses Hierarchy feature. It also includes a 'Leaves' hierarchy which is auto updated by PA. I have one element name 'FF123' which exist in Leaves hierarchy but not in main which ...

Hi Babytiger, You are a star. You were right one of my project had blank for primary site and that was the issue. I never encountered this issue before so I wasn't aware that it always requires an accurate value for such MDX statement. I have already used an alternative cube to resolve this issue bu...

UserID it is just a pseudo code representing static user name like e.g. Admin. what I am trying to do here is generate a dynamic subset for a 'Project' dimension which looks at data in another cube 'z_Security_Site' cube which stores a numeric flag(1) for each user who has access to a site. Z_Securt...

Hi, Thanks for the following up on this thread. I tried the following code but it did not work. Filter( {TM1SUBSETALL([Project])}, [z_Security_Site].([}Clients].[UserID], StrToMember("[Site].["+ [}ElementAttributes_Project].([Project].CurrentMember, [}ElementAttributes_Project].[Primary Si...

Hi gtonkin, Thanks for your help. It did not work, I think its not a correct application of '.Name' function. For the interested readers, I have resolved this issue by creating a new cube with Project and Client Dimension which holds Primary Site access information in the form of flags(1/0) and now ...

Hi Tom, Thank for the quick reply. [Write_Flag] It's a Numeric filed. I can try converting that to string but I doubt that would yield any result as [Write_Flag] field is outside of the scope of StrToMember function. #Filter applied on z_Security_Site Cube Filter( Selecting all element of Project di...

Hi Wim, Many thanks for the reply. I have tried the following different variations earlier but it did not help :cry: Filter( {TM1SUBSETALL([Project])}, [z_Security_Site].( [}Clients].[UserID], StrToMember ("[Site].["+[Project].[Primary Site] +"]") ,[z_Security_Control_Measure].[W...

Hi, I am trying to create a dynamic subset for a 'Project' dimension which looks at data in another cube 'z_Security_Site' cube which stores a numeric flag(1) for each user who has access to a site. Z_Securtiy_Site cube has 3 diemnsions i.e. }client, Site and z_Security_Control_Measure diemsions The...

Hi Jim, Thanks for the reply. At present its not. I just have a list of employee in one dimensions and contracts in another. I received a request from client to group employee by contract in order to improve the usability(this does not mean contract dimension will be deleted) The reason for the requ...

Dear All, I am working on a model wherein I have a dimension name employees (around 500 For the ease of use the client has requested to group employee by contracts(300+). The contracts and employees dimensions will keep growing but contract will change more frequently (on a weekly basis) than employ...

Hi Wim, Thanks for the quick reply. I am getting an error message for all consolidated elements other than regions. Since these items do not have a match with target. I have already included MDX query for Region dimension subset. the data transfer is absolutely fine I was just looking for way to imp...

Hi All, I have an interesting situation, I want to transfer data between two cubes, Cube A and Cabe B . Cube A has 8 dimensions and cube B has 10 dimension. One twist here is Cube A (Source cube) has a dimension name Regions with Hierarchy of Countries > City Cube B has a Region_Consol dimension wit...

Hi Rizwan,

Thanks for the quick reply.
I went through the PMR. but not possible to upgrade ryt now.
Anyother possible solution?? any fix of work around..

Note:- Please dont say string.. I dont want to redo the rules again.

regards,
Lav

Hi All, I am facing a weird issue for TM1 Web. I have two columns which has custom date format (c:dd/mm/yyyy;;) it works fine in cube viewer but on TM1 web format is getting lost. It shows these field in number format and when user is trying to enter date value eg. 01/02/2012 it gives following erro...

Hi Michel, Thank you very much for a quick reply. I have had tried and change my feeders to make it more specific . But its not working. ['WIP YTD','Exp GoLive'] => DB('FA WIP Calc', !Entity, !FA Category PCode, !Currency, 'AOP' , !WIP SRNo, 'Additions WIP' , TIMST((DB('FA WIP Calc', !Entity, !FA Ca...

Hi All Gurus, I am facing a problem with feeders. In this cube I am capturing project wise WIP and calculating Asset Additions based on Expected Golive date. As in Expected Golive Month it gets converted into Asset additions. There can be 10 possible projects and its get consolidated under TOTAL ITE...

Hi All, I have a requirement where I have to copy entire one hierarchical dimesion to another dimension in same order using TI. I went through the forum and there were many post with codes to copy diemension but all were creating messy dimensions. I want something clean and proper. I do understand t...

Hi All, I am looking for a alternative to rules for following situation. I have one consolidation dimension and one measure dimension which includes dates input. Following is an example -----------------Value-------Approval Date---------Exp Go Live Date TOTAL---------5000--------Crap :twisted:------...

Hi Michel,

Very Nice trick... I'll try n see if it works...

Hi Tomok, With all due respect to your comment and without any offenses to whatever you said You should understand basic difference between expertise and curiosity. This site belongs users alike Martin Ryan and Jim who are ready for the dumbest question ever. Like these difference between prolog, me...