Search found 16 matches
- Mon Mar 26, 2018 8:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: consolidated average and consolidation summing together
- Replies: 0
- Views: 2545
consolidated average and consolidation summing together
Hi Everyone I have a client where we multiple dimensions in the cube and multiple levels in the hierarchy in the dimensions. For the one dimension, we would like a consolidated average at the leaf level of this dimension, but when it is not the leaf level, to sum the calculated amount. Take the exam...
- Fri Nov 03, 2017 9:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics Perspectives Issue
- Replies: 10
- Views: 8690
Re: Planning Analytics Perspectives Issue
We have had the same issue. We resolved this by uninstalling the package connector (then restarting the machine)
there is a known issue with perspectives 2.0 installed alongside package connector
there is a known issue with perspectives 2.0 installed alongside package connector
- Tue Dec 02, 2014 2:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Fatal Error
- Replies: 6
- Views: 4381
Re: Fatal Error
Check to see if theLockPagesInMemory=T in TM1s.cfg file. if this is the case, remove it and restart the server. this fixed it for me.
- Tue Apr 01, 2014 5:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: tm1sdx64 error: 0 C12
- Replies: 4
- Views: 7626
Re: tm1sdx64 error: 0 C12
hi Guys
i know this is a late response, but i just had the same issue on my server. it turns out that the antivirus went offline and in doing so, it stopped the service. so maybe have a look at your antivirus if this error occurs again
i know this is a late response, but i just had the same issue on my server. it turns out that the antivirus went offline and in doing so, it stopped the service. so maybe have a look at your antivirus if this error occurs again
- Wed Mar 26, 2014 9:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX problems with drill down
- Replies: 6
- Views: 5946
Re: MDX problems with drill down
hi Guys i managed to speak to someone who works with SQL and they managed to find my problem. the problem was in the query tab, and every thing i tried kept saying SQL statement failed, so i kept trying different things so it wouldn't give me that message i had Business_Unit = (?BusinessUnit?) and i...
- Tue Jan 21, 2014 12:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX problems with drill down
- Replies: 6
- Views: 5946
Re: MDX problems with drill down
hi Robin i must apologize, i didn't give all the information. i am bringing in the data from a Sql table in the data source query, and have vBusinessUnit as a parameter in the drill process. the drill works perfectly, but only on the lowest level of each dimension. the data that comes through from S...
- Tue Jan 21, 2014 10:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX problems with drill down
- Replies: 6
- Views: 5946
MDX problems with drill down
hi Guys i have created a drill process, and it works perfectly at 0 level when we drill from a cube. the problem i am having is that i want to be able to drill at any level of a dimension. i have used info i have found to create a subset using MDX in the prolog tab of the drill process. unfortunatel...
- Thu Jan 16, 2014 5:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Audit Log reports
- Replies: 7
- Views: 14686
Re: TM1 Audit Log reports
hi Guys i have created an audit log cube that says when people were successfully logged in or not, but i am stuck when it comes to not repeating lines that were already captured. i created the look up cube, but dont know how to tell tm1 to ignore all the lines in the file until the date in the file ...
- Thu Oct 17, 2013 6:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unknown error
- Replies: 12
- Views: 11663
Re: unknown error
hi Declan if i run the process, i dont get any error as long as i am using '?division?', and i can drill on the lowest levels in the cube fine with this. but when i try drill on a consolidated level, i get an error that says drill handle was successfully built but did not return a valid handle. chec...
- Thu Oct 17, 2013 6:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unknown error
- Replies: 12
- Views: 11663
Re: unknown error
hi Declan if i run the process, i dont get any error as long as i am using '?division?', and i can drill on the lowest levels in the cube fine with this. but when i try drill on a consolidated level, i get an error that says drill handle was successfully built but did not return a valid handle. chec...
- Wed Oct 16, 2013 1:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unknown error
- Replies: 12
- Views: 11663
Re: unknown error
With this random bit at the end: CODE: SELECT ALL ?Division?') ... but nothing telling it that it should be combining them together into 1 that '?Division?' is quoting that parameter (the Division dimension). if i remove the quotes on either side of it, i get the SQL statement failed. i will have a...
- Wed Oct 16, 2013 12:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unknown error
- Replies: 12
- Views: 11663
Re: unknown error
hi Declan
thanks for the response. unfortunately i'm not too sure wher eto put that code. could you elaborate please?
thanks,
Dale
thanks for the response. unfortunately i'm not too sure wher eto put that code. could you elaborate please?
thanks,
Dale
- Wed Oct 16, 2013 11:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unknown error
- Replies: 12
- Views: 11663
Re: unknown error
i think i have managed to get the Mdx code right as it doesnt show any errors in the asci output SubsetCreateByMdx(sSubName,'{['|sDimName|'].['|sParentElemName|'].Ancestors}'); but i am having difficulty in the Query tab. i have played around and taken the '' away from my parameters, and that works ...
- Wed Oct 16, 2013 9:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unknown error
- Replies: 12
- Views: 11663
Re: unknown error
hi David. thanks for your response. i am busy playing around with the query now as we speak, but had a thought while i was doing it. in my prolog tab, i have the following code to create my hierarchy for the division dimension: [code] SubsetCreateByMdx(sSubName,'{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBE...
- Mon Oct 14, 2013 9:19 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unknown error
- Replies: 12
- Views: 11663
unknown error
hi Guys I have set up a drill process from a Sql table. i get an error message saying "1840 [6] ERROR 2013-10-14 09:03:47.750 TM1.SQLAPI 37000[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'FA'." below is the coding i am using. if i change the division parameter in th...
- Tue Oct 08, 2013 12:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cannot add columns to Excel Table
- Replies: 1
- Views: 1752
Cannot add columns to Excel Table
Hi Guys My client is working on cognos express version 10.1 and pointed out to me that since they have had it installed on their machines, they can no longer add columns to tables created from a Sql Server connection. i have played around with this on my machine which runs of TM1 version 9.5.2 and f...