TM1 Forum

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...

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

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.

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

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...

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...

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...

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 ...

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...

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...

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...

hi Declan

thanks for the response. unfortunately i'm not too sure wher eto put that code. could you elaborate please?

thanks,
Dale

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 ...

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...

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...

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...