Thanks! I'll pass this on to our tech team to figure this out.
Kenneth
Search found 194 matches
- Wed May 17, 2023 12:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBC Connector For SQL Server Using Active Directory Service Account
- Replies: 2
- Views: 1506
- Fri May 12, 2023 7:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBC Connector For SQL Server Using Active Directory Service Account
- Replies: 2
- Views: 1506
ODBC Connector For SQL Server Using Active Directory Service Account
Hi, We have setup ODBC Connector for SQL using DNS Configuration. And for each SQL server TM1 connects to a SQL user account is created in each server. We want to simplify account administration by creating an Active Directory (AD) service account. However we couldn't establish the connection, SQL l...
- Fri May 12, 2023 2:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Filter By Current Member Value Range
- Replies: 2
- Views: 1065
Re: MDX Filter By Current Member Value Range
It works already!
My earlier attempt resulted in wrong expression or ambiguity issue with other dimensions.
Thanks a lot!!
My earlier attempt resulted in wrong expression or ambiguity issue with other dimensions.
Thanks a lot!!
- Fri May 12, 2023 1:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Filter By Current Member Value Range
- Replies: 2
- Views: 1065
MDX Filter By Current Member Value Range
Hi, I'm trying to write a MDX filter statement to return years from 2018 to upcoming budget year (say 2024 for now). This one works. vIndexDim = 1; WHILE(TABDIM(vCube, vIndexDim) @<> ''); vDimName = TABDIM(vCube, vIndexDim); SubsetDestroy(vDimName,vSubset); IF( vDimName @='Year'); vMDX= ' {FILTER ( ...
- Tue Sep 20, 2022 1:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOutput Elements in One Dimension Only
- Replies: 21
- Views: 4381
Re: ASCIIOutput Elements in One Dimension Only
Noted with thanks. Actually I skipped the sString since I only need the project code extracted. The IF check is added at the beginning of the each section before resetting the iTimeCount to 1. The output result is the same so I am sure I'm not missing anything. Kenneth I get it, I'll implement it. K...
- Mon Sep 19, 2022 7:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOutput Elements in One Dimension Only
- Replies: 21
- Views: 4381
Re: ASCIIOutput Elements in One Dimension Only
I get it, I'll implement it.
Kenneth
Kenneth
Wim Gielis wrote: ↑Mon Sep 19, 2022 5:27 pm I would add a couple of:
If ( nFlag = 0);
To avoid processing useless loops.
If you already know that nFlag <> 0, why bother with other loops ?
- Mon Sep 19, 2022 5:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOutput Elements in One Dimension Only
- Replies: 21
- Views: 4381
Re: ASCIIOutput Elements in One Dimension Only
I have implemented yours solution and modified to expand qualifying criteria. In my case the process loop each project for if there's value based on: Current year + each month + Revenue/Expense + Actuals/Budget ledger Previous year + Full Year + Revenue/Expense + Actuals Only the project is extracte...
- Fri Sep 16, 2022 12:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOutput Elements in One Dimension Only
- Replies: 21
- Views: 4381
Re: ASCIIOutput Elements in One Dimension Only
Thanks to all, it's indeed a plentiful of suggestions. I did have the Active flag on mind before going to the forum. I was hoping there's a way that I can output the view that gives me exactly what I want (I don't mind the extra columns) but I think this feature can only be a wishlist. MDX and flag ...
- Thu Sep 15, 2022 11:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOutput Elements in One Dimension Only
- Replies: 21
- Views: 4381
Re: ASCIIOutput Elements in One Dimension Only
Thanks. I was hoping there's an easy way to use TI to extract something very similar to a snap shot, with many horizontal nested columns but first column giving me project without repeating it (which is why I nested the columns). But I do appreciate your offer. Kenneth As I have understood your requ...
- Thu Sep 15, 2022 11:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOutput Elements in One Dimension Only
- Replies: 21
- Views: 4381
Re: ASCIIOutput Elements in One Dimension Only
I don't need the other values at all. The whole exercise is to output a list of project that is active, as defined by whether there's any value based on expenditure or revenue in any month, in actuals or budget ledger. Doing a cube view is just super simple, if I take a snap shot then my project lis...
- Thu Sep 15, 2022 8:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOutput Elements in One Dimension Only
- Replies: 21
- Views: 4381
Re: ASCIIOutput Elements in One Dimension Only
Apologize for confusion. My regular AsciiOutput looks like this: 456 All Dpt Exp P01 Actuals 5 456 All Dpt Rev P01 Actuals -6 456 All Dpt Exp P01 Budget 5 456 All Dpt Rev P01 Budget -5 456 All Dpt Exp P02 Actuals 4 456 All Dpt Rev P02 Actuals -3 456 All Dpt Exp P02 Budget 5 456 All Dpt Rev P02 Budge...
- Thu Sep 15, 2022 7:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOutput Elements in One Dimension Only
- Replies: 21
- Views: 4381
Re: ASCIIOutput Elements in One Dimension Only
Consolidation for Dep is not the issue but consolidating Exp and Rev could be if there're offsetting negatives. My example shows Revenues in positive but in my data it's negative. More than this, I would need to nest the columns with 12 months and 2 ledgers. That means my extraction file would have ...
- Thu Sep 15, 2022 5:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOutput Elements in One Dimension Only
- Replies: 21
- Views: 4381
Re: ASCIIOutput Elements in One Dimension Only
Hi Wim, thanks for replying. I noticed my original post wasn't the most intuitive in asking the question. I have now edited what I want to achieve better. Kenneth You have more than 180 posts here, I would assume that this task is not so difficult. In the view that is the data source to the process,...
- Thu Sep 15, 2022 2:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOutput Elements in One Dimension Only
- Replies: 21
- Views: 4381
ASCIIOutput Elements in One Dimension Only
Hi all, I use AsciiOutput to export cube data without problem. I have a new requirement that I need to export only the element of one dimension. The element is short listed based on the cube view. This is a sample before zero suppression: Project Dept Expenditure Revenue 123 A 0 0 456 B 10 5 789 C 1...
- Tue Sep 06, 2022 2:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Powershell Snd-MailMessage Fail to Attach File
- Replies: 16
- Views: 2303
Re: Powershell Snd-MailMessage Fail to Attach File
Thanks! I'll probably stick with what I have for now. We wanna keep things as simple as possible since we don't have the admin. right to the Windows server and we can only work with whatever we can in Architect. Kenneth When I was testing -Attachments, it's all run from Prolog. I was testing to atta...
- Tue Sep 06, 2022 2:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Powershell Snd-MailMessage Fail to Attach File
- Replies: 16
- Views: 2303
Re: Powershell Snd-MailMessage Fail to Attach File
When I was testing -Attachments, it's all run from Prolog. I was testing to attach a file already in the data directory. Now it's run from Epilog, attaching a file in the data directory. There's no asciiOutput run at all. Kenneth The command has to be run in Epilog not Prolog. Not sure why because t...
- Tue Sep 06, 2022 1:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Powershell Snd-MailMessage Fail to Attach File
- Replies: 16
- Views: 2303
Re: Powershell Snd-MailMessage Fail to Attach File
After trying a few things I got the answer.
The command has to be run in Epilog not Prolog. Not sure why because the working TI has been in Prolog all the time.
Also the attachment operator should be: -Attachments ' | ' \ " ' |pAttachment| '\"
Now it's working.
The command has to be run in Epilog not Prolog. Not sure why because the working TI has been in Prolog all the time.
Also the attachment operator should be: -Attachments ' | ' \ " ' |pAttachment| '\"
Now it's working.
- Sun Sep 04, 2022 7:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Powershell Snd-MailMessage Fail to Attach File
- Replies: 16
- Views: 2303
Re: Powershell Snd-MailMessage Fail to Attach File
The file to be attached is actually on the same drive as TM1 data (E: drive). I suppose I can test it in my local machine but then if works in local machine but not on TM1 server then what's does it mean? Kenneth sAttachment = 'E:\System\ExtractFiles\Test.csv'; Regarding the file path, "E:\Syst...
- Sun Sep 04, 2022 7:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Powershell Snd-MailMessage Fail to Attach File
- Replies: 16
- Views: 2303
Re: Powershell Snd-MailMessage Fail to Attach File
Just wondering but I suppose I can still call the script from TI right? If so, then yes please share I definitely appreciate it. Kenneth To answer all: https://edu.cubewise.com/2019/11/13/tips-how-to-email-a-report-using-tm1/ - Tested 2 spaces and 1 space have no difference - "Attachments"...
- Sat Sep 03, 2022 1:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Powershell Snd-MailMessage Fail to Attach File
- Replies: 16
- Views: 2303
Re: Powershell Snd-MailMessage Fail to Attach File
To answer all:
https://edu.cubewise.com/2019/11/13/tip ... using-tm1/
- Tested 2 spaces and 1 space have no difference
- "Attachments" not "Attachment"
https://edu.cubewise.com/2019/11/13/tip ... using-tm1/
- Tested 2 spaces and 1 space have no difference
- "Attachments" not "Attachment"