TM1 Forum

You will also get this error if you have a view that includes one or more dimension elements that have since been removed from a dimension. Hi Tomok, I checked this scenario manually by creating some dummy dimennsion and a cube with those dimensions I handpicked some elements from that dimension an...

I still get the error. You get the error or the user get's the error? What about security on the dimensions in the cube? Are any of them restricted and if so, does the user have the proper access to all the elements in the view? Hi Tomok, Am facing the same problem in my application When i searched...

{[All]}+{TM1SORT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [DimName] )}, 0)}, DESC)} Thanks tomok, It worked good, but i complexed it using UNION :D {UNION({TM1FILTERBYLEVEL( {TM1SUBSETALL( [Dim_name] )}, 1)}, {TM1SORT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Dim_name] )}, 0)}, DESC)})} Thanks again :)

Hi, I am having an dimension with the following structure All Aaaa Bbbbb Ccccc Ddddd It has one parent and all leaf elements I want the elements to be sorted in descending order with the hierarchy retained(the parent element retained) I used the following MDX { HIERARCHIZE( {TM1SORT( {TM1SUBSETALL( ...

But could you explain me in detail how to filter the employee list using an MDX for active form report, i mean where i should use the mdx query whether inside a TI process or in reports? You use the MDX within the TM1ReportRow formula. Same MDX same syntax (minus TM1SubsetBasis) as if you were to r...

It is also possible to do this in Cube Viewer by using MDX subsets that reference your picks for other dimensions (contextual, cascading selections). More on this in this thread . hi qml, i tried as said in the link by creating two attributes for the dimensions and it worked like charm, this is wha...

Thanks tomok

Tomok,Thanks to know that it is the best way for the cube view

But could you explain me in detail how to filter the employee list using an MDX for active form report, i mean where i should use the mdx query whether inside a TI process or in reports?

Thank you
Regards
Guru

Hi, i have a cube called employee plan that has employees and country dimension suppose if i select a country say IND, i need employee dimension to display only the employees of IND. I have the country name as an attribute for all employee. Fortunately in the empDetails dimension(in the same cube vi...

Hi,

i missed a point,

i am able to login to the contributor if i use the url

http://cognosBIservername:9300/pmpsvc/

but when i login through http://localhost:8080/pmpsvc in my TM1 environment, its throwing this error.

Hi

i tried it ,i changed the var planning services =["http://fqdnservername of the cognos BI:9300"];

my cognos BI and cognos TM1 are in different servers

but still it is throwing the same error
kindly give me a solution for this issue

Regards
Guru

Hi jim,

its a NO, contributor and cognos 10 BI are in different servers

Hi, i am using cognos tm1 9.5.2 with cognos 10 BI security (using LDAP) During the configuration, i was asked to ensure the placement of these files from tm1 to c10 in the following folders From tm1 install dir to c10 Install dir Cadmin\pmpsvc.war-----------------------------------c10 \webapps \Cadm...

hi Jim, Thanks a lot for your reply i have checked those things, they are fine, i think i am wrong at the concept of webserver the path to open the tm1 contributor for web client is http://webserver/tm1web/contributor.aspx what is the 'webserver' in this url mean i am trying to open it with the ip o...

Sorry jim,

Could you explain me in detail about this, I could not understand those things,

Thanks in Advance
Guru

Thank you very much for your replies jim was correct , i was doing this with my cognos BI service running so i was not able to delete that tm1ja64.dll file so now its working fine. As Andy said i deployed the war file again without reinstalling the tm1 contributor now i am able to open my tm1 contri...

Hi, For the configuration of the Contributor, i initially deployed the pmpsvc.war file into apache tomcat and i was able to open my contributor but later because of some confusions, i undeployed it and deleted the following files as mentioned in the IBM Cognos Tm1 guide i am using cognos tm1 9.5.2 w...

Hi All, My project phase has two environments We do our developments and testing in testing environment and move those files to the production environment For moving rule files , we need to move the rux and blb file of that cube(if i am not wrong) While moving those files, i encountered that the cha...

Thanks for your reply about the issue

Hi, My requirement is like this I have to upload an csv file into the TI process from an ftp site This ftp is located as a folder in the server of TM1 for eg, if this is the ftp that i am using ftp://160.60.6.190, the files placed in here are stored in an path local to the server in the E drive So w...