Search found 38 matches

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: 1411

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: 605

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: 401

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: 12021

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: 12021

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:\Program Files...
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: 987

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: 273

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: 273

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: 987

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: 987

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 select "HR" ...
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: 23105

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: 23105

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: 23105

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: 23105

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 that is not...
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: 23105

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: 486

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: 486

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 level is 3 f...
by Hector2005
Thu Mar 15, 2018 6:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing dimension attribute values based on filter selection
Replies: 15
Views: 1872

Re: Changing dimension attribute values based on filter selection

Unless you are needing the labels to vary because of reporting requirements by the users, Orlando's solution should do it. However, if you really do need the labels to change, another solution is to use an MDX subset on the Month dimension. Add elements to your month dimension for each year/month c...
by Hector2005
Tue Mar 13, 2018 11:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing dimension attribute values based on filter selection
Replies: 15
Views: 1872

Re: Changing dimension attribute values based on filter selection

Dear professionals, Is there a way in Rules I can do to push data into another cube from this cube.

Ex: if I'm in X cube I want to push data to Y cube using Rules.
This will solve my problem.

Thanks a lot,
Best Regards.
by Hector2005
Tue Mar 13, 2018 12:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing dimension attribute values based on filter selection
Replies: 15
Views: 1872

Re: Changing dimension attribute values based on filter selection

Dear all, Appreciated for your aid.

Please this what I ask for.