Search found 41 matches

by Hector2005
Thu Feb 06, 2020 5:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Buttons parameters & Filtering two dimensions on the same side
Replies: 1
Views: 1876

PAW Buttons parameters & Filtering two dimensions on the same side

Hello professionals, hope my message finds you great. :D :D Actually, I have two questions. :?: The first one, I am working over PAW and I am facing a problem regarding PAW buttons and selections. So, Do you have any idea in how to pass filter selections to the PAW button's parameters automatically ...
by Hector2005
Sat Feb 01, 2020 7:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filter with IIF and Count MDX
Replies: 3
Views: 3971

Re: Filter with IIF and Count MDX

First thing to consider when using IIF is what type of result we will get from the THEN and ELSE. I'm sure you've looked at the MDX Primer for this (as I did a while ago when having a similar requirement) and found the example relating to the IIF being used to decide whether to filter by the top 5 ...
by Hector2005
Fri Jan 31, 2020 8:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filter with IIF and Count MDX
Replies: 3
Views: 3971

Filter with IIF and Count MDX

Hello Everybody, hope you are doing great. Suppose I have a cube which is called [Subsidiary Year Mapping] and relates Year dimension and Subsidiary dimension. What I want to make a dynamic subset to check if the current year doesn't have any subsidiaries, then return something, otherwise return the...
by Hector2005
Wed Nov 21, 2018 5:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drills - Not working for users
Replies: 9
Views: 5901

Re: Drills - Not working for users

Hi Ashish, regarding your 1st question, just give them (another user) a read access in drill process. Steps: 1. Go to View check the Display Object Options 2. Go to Processes right click > Security Assignments then look for user group and drill process (ex: }Drill_Master Cube) then click Read optio...
by Hector2005
Mon Sep 24, 2018 4:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sandbox Manipulation (Reset/Commit)
Replies: 0
Views: 2616

Sandbox Manipulation (Reset/Commit)

Hello everyone, Hope you are okay. My story is that I wanna simulate the TM1 application but I don't need approval hierarchy anymore. because I wanna do it through a set of users not a hierarchy. This task requested later before deploying our solution. we are using Planning Analytics workspace and I...
by Hector2005
Wed Jul 25, 2018 9:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Refreshing of planning Analytics Workspace filters.
Replies: 1
Views: 2178

Refreshing of planning Analytics Workspace filters.

Hello there, I have a question. My problem: I have made a solution based on cognos TM1 and user interface using Planning analytics, then I made a process to rebuild cube view based on some selections in other cube. The data refreshed and the cube created but 'The filters keep the old value, So you n...
by Hector2005
Fri Jul 20, 2018 2:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Datasource Path
Replies: 43
Views: 31804

Re: Dynamic Datasource Path1

TIs don’t accept xls or xlsx etc rules as a source, it needs a flat file to read (CSV, CMA, TXT etc.) I believe performance modeller could accept excel files but I think that just had an additional program that converted it to a CSV first, you can do something similar yourself by having VBS execute...
by Hector2005
Thu Jul 19, 2018 9:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Datasource Path
Replies: 43
Views: 31804

Re: Dynamic Datasource Path

Hello Guys, I have a problem to assign the file path in runtime. I have made a ti process and select the type is File then assigned a template Excel file "Just contained a header" I attached it. after that I opened the prolog tab : and wrote the following. DataSourceNameForServer = 'C:\Pro...
by Hector2005
Sat Jul 14, 2018 8:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Making a Cascaded Filter(Filter depends on another filter) in TM1
Replies: 5
Views: 4886

Re: Making a Cascaded Filter(Filter depends on another filter) in TM1

I guess another possible option (depending on circumstances) would be to have one dimension for Department and areas where Department is the parent and Area is the child. Then create a subset for each department. cheers, Mark Thanks a lot man, But this will not Solve my problem because I have many ...
by Hector2005
Tue Jul 03, 2018 4:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing a process while the Drill through process Execution
Replies: 2
Views: 2063

Re: Executing a process while the Drill through process Execution

You can create any custom view you want within the drill-through process. You can even create and populate a custom cube, build a view on it and open it. Unless it has changed in PA2.0, I do not believe you can use ReturnViewHandle in anything but a drill process. For using TM1RunTI and passing par...
by Hector2005
Tue Jul 03, 2018 11:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing a process while the Drill through process Execution
Replies: 2
Views: 2063

Executing a process while the Drill through process Execution

Hello Guys, Actually I searched in many posts and Blogs but zero result. My problem is: I have a cube with many dimensions contains many elements and there is a good way to move from view to (another different view) called drill through, IF I Can create view using TI Process while the execution of t...
by Hector2005
Wed May 30, 2018 7:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Making a Cascaded Filter(Filter depends on another filter) in TM1
Replies: 5
Views: 4886

Re: Making a Cascaded Filter(Filter depends on another filter) in TM1

Are you trying to achieve this in a CubeView or in a Websheet? You need to have some attribute (or to build a cube that holds your dimensions relationships). Then build MDX Statement to filter only Areas of your Selected Department. You can store the Selected Department in a cube with a DBSS. (I us...
by Hector2005
Wed May 30, 2018 12:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Making a Cascaded Filter(Filter depends on another filter) in TM1
Replies: 5
Views: 4886

Making a Cascaded Filter(Filter depends on another filter) in TM1

Hello there, Please can anyone support me in this case. I searched many but empty hands. Consider the following cube with 6 dimensions (4 are filters in the context area). Two of them are Department and areas. If I select "IT" for example I want the next filter to load some ares, When I se...
by Hector2005
Fri May 04, 2018 1:10 pm
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 73571

Re: Copying Data from 1 Element to Another via TI

No one is going to write your code for you. You need to understand the fundamentals of what a TI process does and how the data is processed one-cell-at-a-time. That's all from me untill you can prove that you have read and understood the request for assistance guidelines. Hello there, Firstly, than...
by Hector2005
Thu May 03, 2018 12:55 am
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 73571

Re: Copying Data from 1 Element to Another via TI

Go back and RTM. Epilog code is executed once and once only after the data source connection is closed. Any CellPutN here would update only one cell. For the data source you of course want to select a view of the source cube that you will be processing. The manually selected view serves one purpose...
by Hector2005
Tue May 01, 2018 2:30 pm
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 73571

Re: Copying Data from 1 Element to Another via TI

You are building a view sure. But I see no DatasourceType=‘VIEW’ or DatasourceNameForServer=sCube in your Prolog code. If you have set up the variables using a text data source then as Alan already suggested the NValue variable will be undefined. Code only does what you tell it. Also when using a v...
by Hector2005
Tue May 01, 2018 11:03 am
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 73571

Re: Copying Data from 1 Element to Another via TI

Hello there, After doing this process, It raised an error in the Data Tab that "NVALUE" isn't defined. Anything I missed? Thanks a lot, Mohamed Al-Bana. I think we would need to see the code before we could answer that. However at a guess, you have tried to use NValue with a data source t...
by Hector2005
Tue May 01, 2018 9:28 am
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 73571

Re: Copying Data from 1 Element to Another via TI

Hello there,
After doing this process, It raised an error in the Data Tab that "NVALUE" isn't defined.

Anything I missed?

Thanks a lot,
Mohamed Al-Bana.
by Hector2005
Mon Apr 30, 2018 2:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Number of levels above an element
Replies: 4
Views: 3515

Re: Number of levels above an element

Thanks a lot for your concern, Sorry about my latency but I think I will search on another way to get a solution.

Best Regards,
by Hector2005
Fri Apr 27, 2018 1:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Number of levels above an element
Replies: 4
Views: 3515

Number of levels above an element

Hello there, hope all of you is okay. I have a little question. If I have this hierarchy -Corporate China +America +Japan -India +Exploration -Development X Is there a way through it I can know number of levels above any leaf element for example "X" number of levels or the last ancestor le...