TM1 Forum

Fantastic lads! Love this forum!

Hi Guys, Testing connectivitly to a drill through source from an access database. I am trying to drill through to the following. However the TM1 view I have has alias's turned on for the "coo_auext" dimension to show desriptions. I thought it may be possible to try: [Profit ctr1] = '?SUBST...

Thanks Martin, after 4 yrs of using this product, it still amaze's me there are still things to be learnt.

Cheers

Shock

Thanks Paul Simon, Yep, to get around the rule error I just prefixed it with the dimension that i needed. Checked the all the alias's and there appears to be no double up with other elements within other dimensions..... Going to let this lay to rest, at least i have a work around. I did see you ment...

Sorry Alan, i believe this is not the first time i have mis-spelt your name. Thanks for your help.

Cheers

Shcok

thinking our aloud, ignore last post.

just had a thought it.... it might be the blob file... hmm

Hi Allan, Made the script change as suggested. Spelling is correct and it still picks it up even though I cannot visibly see it on screen when i search for it or when i export the dimensions :cry: NumDimensions = DIMSIZ('}Dimensions'); NumDimInit = 1; dimNameStr = ','; element='actVBudget'; eleFound...

Hi Allan, Nothing wrong with the script. The script picks up the fact the element exists in 2 dimensions. Maybe if have missing something???? NumDimensions = DIMSIZ('}Dimensions'); NumDimInit = 1; dimNameStr = ','; element='actVBudget'; While(NumDimInit<=NumDimensions); dimName = DIMNM('}Dimensions'...

Hi All, How do i permently delete an element from a dimension? Is the only way by destroying the dimension and rebuilding the hierarchy?? I have an issue where I get an "element is ambiguous" error within my rule file. I have written a script to identify what dimensions element "x&quo...

Sorted it, there was a syntax error that was not picked up but it appears that i need to place '{}' around each of my tuples in order for it to work ie { {tuple1}, {tuple2} } instead of { tuple1, tuple2 } which has fixed the problem and the fact there was no data to start off with!! Must be Friday. ...

Hi All, I am having an issue with a statement i am creating and for some reason I cannot add any more crossjoined tuples on rows. When i add an additional tuple to my existing set it errors out. Is this a limitation within TM1 with multiple crossjoin statements or is there something missing from my ...

Hi All, Inspired by KevinB I have a produced a working mdx view using the tm1.api. The code may be a little sloppy though. If other people have other examples can they please post them. There is just not enough information out there when it comes to the tm1.api and its a shame to see. Here it is: Im...

Hi George, Thanks for your reply. Running this through customer .net. Because a code error the connection was kept open. Just had to disconnect myself within TM1 and the issue was resolved (thanks Ben). I thought this may have been some sort of ISS thing, but was wrong on this occasion. Cheers Shock

Hi Guys, is there a way to clear this on the server?? Off the top of my head there some setting in IIS to reset connections or something ( I think this is it) am i wrong here?? If this is what it is how do i reset this?? TM1APIDOTNET Exception: Maximum number of connections exceeded on the server. C...

Yep Ben thats right. Working in the back end most of the time this is the first time in 3yrs someone has flagged it. Just seemed unusal at the time but make perfect sense. How is the new tool going??

Thanks Alan. I wish I was taking the u know what, maybe I should RTFM. Something I obviously overlooked.

Thanks again

Shock

Hi Alan, a) not writing send back data into the cube but tring to overwrite a single cell ( with a DBRW formulae) with a hardcoded number in an excel spreadsheet b) the elements have read permission but all the user is doing is overwritting the formulae c) the elements that are being overridden are ...

Hi All, A couple of our users have encountered a strange issue where when data is sliced into excel and user tries to overwrite that tm1 forumulae referenced cell with a hard coded number it returns the following error: " T1) Write Access Denied " Has anyone encounted this error b4?? Or ha...

Hi Guys, was able to come up with a more reliable way by creating a view loading the souce cube and then destroying the view, but still confused to why when running the mdx query within TI it gives me multiple columns as opposed to what it looks like in screenshot a... Can anyone shed some light on ...