Search found 30 matches

by lav4you
Wed Feb 20, 2019 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 671

Re: MDX StrToMember Error

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...
by lav4you
Tue Feb 19, 2019 11:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 671

Re: MDX StrToMember Error

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...
by lav4you
Tue Feb 19, 2019 1:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 671

Re: MDX StrToMember Error

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 Site] ) +"]"...
by lav4you
Mon Feb 11, 2019 12:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 671

Re: MDX StrToMember Error

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 ...
by lav4you
Sat Feb 09, 2019 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 671

Re: MDX StrToMember Error

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...
by lav4you
Sat Feb 09, 2019 11:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 671

Re: MDX StrToMember Error

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].[Write_Flag])>0 ) Filt...
by lav4you
Fri Feb 08, 2019 6:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 671

MDX StrToMember Error

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...
by lav4you
Thu Oct 08, 2015 1:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset vs Alternative Hierarchy
Replies: 4
Views: 1084

Re: Subset vs Alternative Hierarchy

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...
by lav4you
Thu Oct 08, 2015 11:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset vs Alternative Hierarchy
Replies: 4
Views: 1084

Subset vs Alternative Hierarchy

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...
by lav4you
Thu Jul 05, 2012 2:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewCreate with keeping consolidation for data transfer
Replies: 3
Views: 676

Re: ViewCreate with keeping consolidation for data transfer

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...
by lav4you
Thu Jul 05, 2012 10:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewCreate with keeping consolidation for data transfer
Replies: 3
Views: 676

ViewCreate with keeping consolidation for data transfer

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...
by lav4you
Tue Jun 19, 2012 3:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web Date Format
Replies: 2
Views: 926

Re: TM1 Web Date Format

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.. :x I dont want to redo the rules again.

regards,
Lav
by lav4you
Tue Jun 19, 2012 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web Date Format
Replies: 2
Views: 926

TM1 Web Date Format

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...
by lav4you
Fri Jun 15, 2012 1:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Please help me with feeders
Replies: 2
Views: 530

Re: Please help me with feeders

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...
by lav4you
Fri Jun 15, 2012 9:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Please help me with feeders
Replies: 2
Views: 530

Please help me with feeders

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...
by lav4you
Fri May 25, 2012 2:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Hierarchical Dimension
Replies: 3
Views: 1943

Copy Hierarchical Dimension

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...
by lav4you
Thu May 17, 2012 3:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to avoid Date Consolidation
Replies: 3
Views: 826

How to avoid Date Consolidation

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:------...
by lav4you
Wed May 02, 2012 12:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sort a TI created subset
Replies: 13
Views: 6915

Re: Sort a TI created subset

Hi Michel,

Very Nice trick... I'll try n see if it works...
by lav4you
Mon Jan 02, 2012 8:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Suggestion on Model Design
Replies: 9
Views: 1307

Re: Suggestion on Model Design

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...
by lav4you
Thu Dec 29, 2011 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Suggestion on Model Design
Replies: 9
Views: 1307

Re: Suggestion on Model Design

Hi, Hierarchy is not must for my model requirement. Since I am going to build a large dimension(approx 30,000 elements), i just want to know whether I must include all items as leaf node without hierarchy or I must create a hierarchy levels? which dimension structure will give best overall performan...