Hi Wim,
I can use either.
Right now the report is authored in Perspectives but will be converted to PAfE soon enough.
Search found 27 matches
- Wed Feb 22, 2023 9:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX filter for two dimensions
- Replies: 6
- Views: 1419
- Wed Feb 22, 2023 8:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX filter for two dimensions
- Replies: 6
- Views: 1419
MDX filter for two dimensions
Hi all, Just looking to confirm if the following situation is possible. I don't believe it is, but would like to confirm and maybe get some thoughts on what is possible. I have a dynamic report created from a 3 dimensional cube: Order # Line Measures In the rows I have Order #, Line, and several mea...
- Thu Aug 25, 2022 1:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Websheet rendering on different devices
- Replies: 1
- Views: 594
Websheet rendering on different devices
Hi everyone, Wondering if there is a way to make a websheet in PAW render the same regardless of what type of device it is being viewed on? When a user views a particular book from a laptop it renders with vertical/horizontal scroll bars as compared to when viewing on a larger desktop monitor. I’m w...
- Wed May 25, 2022 2:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Converting perspectives reports to Pafe
- Replies: 2
- Views: 1136
Converting perspectives reports to Pafe
Hi all, Just looking for some thoughts on converting perspectives reports to the Pafe version. Here are some details: Some of the perspectives reports contain quite a bit of VBA. The VBA does things like snaps out the entire book to a static excel sheet, converts the entire report to PDF, sets date ...
- Thu Apr 21, 2022 7:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX wildcard filter based on cube value
- Replies: 9
- Views: 2160
Re: MDX wildcard filter based on cube value
Thank you Declan. That works well. One small wrinkle though if the lookup cell value is bob (lower case) instead of Bob this doesn't work. I'd have to account for users typing in either I imagine. I found this which actually works very well in PAW but not in PAX. {FILTER([Line].MEMBERS,Instr(1,[Sale...
- Thu Apr 21, 2022 4:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX wildcard filter based on cube value
- Replies: 9
- Views: 2160
MDX wildcard filter based on cube value
Hi all, Just looking for a bit of advice compiling an MDX statement. Here are some details: I have a 2 dimensional cube called Sales which contains a Line dim and Measures. I want to apply filters to the line dim based on values in the cube. I'm able to apply filters properly when the value typed in...
- Sat Mar 19, 2022 7:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBC Output with delimiters in values
- Replies: 1
- Views: 1685
ODBC Output with delimiters in values
Hi all, Just looking for a bit of advice to see if there is an easy way to solve this before I go down a path that will cause a lot of time/effort to be spent on developing something. Here are some details of what I'm trying to do: I have a cube that I'd like to export to a SQL DB. The cube has 80+ ...
- Thu Nov 04, 2021 1:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBC Output using Update Function
- Replies: 4
- Views: 7793
Re: ODBC Output using Update Function
Thanks guys for your replies.
I followed the example from this post below.
viewtopic.php?t=9490
In any case with or without the Expand function It's working which is what I care about.
Thanks again.
Cheers!
I followed the example from this post below.
viewtopic.php?t=9490
In any case with or without the Expand function It's working which is what I care about.
Thanks again.
Cheers!
- Thu Nov 04, 2021 3:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBC Output using Update Function
- Replies: 4
- Views: 7793
Re: ODBC Output using Update Function
I got this sorted. Rather than delete the post I'll paste what I did here in case it's useful for anyone else. After searching through the posts on here I initially tried the expand Function in my statement but didn't work without realizing I needed to declare a variable for the Expand function to w...
- Thu Nov 04, 2021 3:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBC Output using Update Function
- Replies: 4
- Views: 7793
ODBC Output using Update Function
Hi all, Looking for a bit of advice on an ODBC Output to a SQL table. Here are the details: I have a column in the the table called [Date] format is Date, Null There are dummy records in this date field which are populated with 1900-01-01. I would like to convert all of those dates to a NULL. When I...
- Thu Dec 10, 2020 4:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: User Upload csv files through PAW interface
- Replies: 4
- Views: 2420
Re: User Upload csv files through PAW interface
Hi Wim, Makes sense thanks for the reply! What I'd like to know is if a user would be able to click a link from PAW and have the sub-folder pop open on screen. Is this possible? I've read posts about customizing virtual directories in IIS but I believe that applies to hyperlinks from perspectives we...
- Wed Dec 09, 2020 10:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: User Upload csv files through PAW interface
- Replies: 4
- Views: 2420
User Upload csv files through PAW interface
Hello all, Just looking for a bit of advice on having multi-users upload data to TM1 via PAW. Here's the details: -Multiple users will input data offline into a standard template -Security is controlled via a Department dimension for each user What I've done in the past using TM1 Web is provide a hy...
- Mon Oct 26, 2020 1:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule/Feeders for currency conversion
- Replies: 5
- Views: 1938
Re: Rule/Feeders for currency conversion
Hi Wim,
I believe we are both aligned with our thinking on the requirements.
The client has agreed that it makes sense to calc via rule only 5-6 currencies and make available on demand to calc to any other currency via TI.
I appreciate your responses and attention to this topic.
Cheers!
I believe we are both aligned with our thinking on the requirements.
The client has agreed that it makes sense to calc via rule only 5-6 currencies and make available on demand to calc to any other currency via TI.
I appreciate your responses and attention to this topic.
Cheers!
- Fri Oct 23, 2020 9:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule/Feeders for currency conversion
- Replies: 5
- Views: 1938
Re: Rule/Feeders for currency conversion
Hey Wim, Thanks for your reply. Everything you posted makes total sense to me. Also the thought of adding "local" as a child had occurred to me as well and the rule works well even eliminating the feeder is great but it got a little muddy when consolidating Regions since the consol dept ca...
- Fri Oct 23, 2020 8:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule/Feeders for currency conversion
- Replies: 5
- Views: 1938
Rule/Feeders for currency conversion
Hi all, Just looking for some advice on how to structure rules/feeders for fx conversion. I have provided sample screenshots below of the cube structures. Essentially I am moving from an input cube to a reporting cube which runs 50+ currency conversions (each regional user would like to represent th...
- Wed Feb 26, 2020 3:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pass a parameter to SQL stored procedure
- Replies: 1
- Views: 1667
Pass a parameter to SQL stored procedure
Hi all, I'm looking for some advice on executing a SQL stored procedure from within a TI. Here's what I've done. I have a parameter ( pLoadNumber ) which is Numeric and the value will always change but for this example lets say the value is 100.0000 I need to pass this parameter to a stored procedur...
- Fri Nov 01, 2019 7:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cost allocations by Department & Employee
- Replies: 0
- Views: 6819
Cost allocations by Department & Employee
Hello all, I'm looking for an efficient way to setup rules to capture departmental salary allocations by employee and would appreciate any advice. Basically there should be an input of allocation % by Department and by Employee. This would be the source view or the sender view. The receiver of the a...
- Thu Aug 29, 2019 5:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Leading zeros in AsciiOutPut being dropped
- Replies: 4
- Views: 11623
Leading zeros in AsciiOutPut being dropped
Hello everyone, Just a quick question as I'm dealing with an issue which I'm sure has been solved but can't seem to find anything on this. I'm doing an ASCIIOUTPUT and one of the fields is an account dimension. This account dimension has 6 digits and various accounts include leading zeros i.e. 00012...
- Thu Mar 21, 2019 7:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sort cubes alphabetically in PAW after applying cube aliases
- Replies: 2
- Views: 1929
Sort cubes alphabetically in PAW after applying cube aliases
Hello all, Was looking for some advice if there is some sort of config setting which would allow me to sort my cubes alphabetically in TM1 Web & PAW after applying a caption attribute? Here are the details: The image below are the original cube names: Original Cube Names.png This image are the c...
- Thu Jul 19, 2018 1:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Zero out cube view from source elements
- Replies: 5
- Views: 5150
Re: Zero out cube view from source elements
Thank you folks I did figure this out taking into account some of your feedback.
Much appreciated!
Cheers
Much appreciated!
Cheers