Search found 41 matches
- 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: 1888
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 ...
- 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: 4019
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 ...
- 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: 4019
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...
- Wed Nov 21, 2018 5:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drills - Not working for users
- Replies: 9
- Views: 5950
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...
- Mon Sep 24, 2018 4:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sandbox Manipulation (Reset/Commit)
- Replies: 0
- Views: 2755
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...
- 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: 2189
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...
- Fri Jul 20, 2018 2:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Datasource Path
- Replies: 43
- Views: 32034
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...
- Thu Jul 19, 2018 9:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Datasource Path
- Replies: 43
- Views: 32034
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...
- 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: 5001
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 ...
- 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: 2079
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...
- 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: 2079
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...
- 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: 5001
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...
- 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: 5001
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...
- 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: 74758
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...
- 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: 74758
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...
- 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: 74758
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...
- 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: 74758
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...
- 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: 74758
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.
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.
- 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: 3540
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,
Best Regards,
- 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: 3540
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...