Search found 194 matches

by kenship
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: 1480

Re: ODBC Connector For SQL Server Using Active Directory Service Account

Thanks! I'll pass this on to our tech team to figure this out.

Kenneth
by kenship
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: 1480

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...
by kenship
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: 1051

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!!
by kenship
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: 1051

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 ( ...
by kenship
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: 4326

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...
by kenship
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: 4326

Re: ASCIIOutput Elements in One Dimension Only

I get it, I'll implement it.

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 ?
by kenship
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: 4326

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...
by kenship
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: 4326

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 ...
by kenship
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: 4326

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...
by kenship
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: 4326

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...
by kenship
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: 4326

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...
by kenship
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: 4326

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 ...
by kenship
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: 4326

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,...
by kenship
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: 4326

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...
by kenship
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: 2280

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...
by kenship
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: 2280

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...
by kenship
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: 2280

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.
by kenship
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: 2280

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...
by kenship
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: 2280

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"...
by kenship
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: 2280

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"