Search found 27 matches

by CRP0021
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

Re: MDX filter for two dimensions

Hi Wim,
I can use either.
Right now the report is authored in Perspectives but will be converted to PAfE soon enough.
by CRP0021
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...
by CRP0021
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...
by CRP0021
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 ...
by CRP0021
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...
by CRP0021
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...
by CRP0021
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+ ...
by CRP0021
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!
by CRP0021
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...
by CRP0021
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...
by CRP0021
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...
by CRP0021
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...
by CRP0021
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!
by CRP0021
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...
by CRP0021
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...
by CRP0021
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...
by CRP0021
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...
by CRP0021
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...
by CRP0021
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...
by CRP0021
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 :)