Search found 120 matches
- Tue Jul 23, 2024 7:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Migrating Cognos Users Namespace
- Replies: 1
- Views: 2429
Re: Migrating Cognos Users Namespace
Hi there, some time Ago we migrated Cognos to a new server and switched from ApacheDS to ActiveDirectory LDS. IIRC you have to ensure that the Namespace and path is the same in the new LDAP as in the old one, also this must be setup before importing the content store, otherwise you should see errors...
- Tue Jul 23, 2024 7:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Rule issue using NUMBR() function
- Replies: 8
- Views: 6307
Re: TM1 Rule issue using NUMBR() function
For me it looks like your 2nd Example is using the 's Value' Element from the same Cube, in that case you would need to write the rule like this:
Code: Select all
[ 'N Value' ] = N: NUMBR ( ['S Value'] ) ;
- Wed Mar 20, 2024 12:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Potential Change to css
- Replies: 1
- Views: 1704
Re: Potential Change to css
Hi there, Not tried it, as we use SSO but i think you can Edit the "LoginDialog.html" file in "ibm\cognos\tm1web\webapps\tm1web\scripts\tm1web\api\session\templates".. I would remove the div for the changePassword checkbox. ... <div style="display:none"> <input type=&qu...
- Thu Aug 24, 2023 6:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos security group database
- Replies: 5
- Views: 2577
Re: Cognos security group database
We use it on TM1, it can delete clients from }Clients on TM1, but we have to delete them from Cognos BI security group too. Hi, do you use Cognos Groups or do you use LDAP Groups in Cognos? If you use LDAP Groups you should automate there, otherwise IBM has a Example how to Add Everyone to SystemAd...
- Wed Aug 23, 2023 7:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos BI
- Replies: 3
- Views: 3723
Re: }ClientGroups cube not in sync. with Cognos BI
Hi, normally they should be assigned to the Groups in TM1/PA when logging in, not just in the WebClients. I had similar issues with some Users and it seems to be a Bug, as removing the User worked everytime to fix the issue (after removing they will be updated correctly again, even if you assign new...
- Tue Aug 22, 2023 1:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use Sandbox in process
- Replies: 2
- Views: 1424
Re: Use Sandbox in process
Looks like what I have used previously for testing. I typically run these commands in Prolog (activate) and Epilog (deactivate) and have not seen any issues so far but saying that have not used these for over a year. Hi there! yea i do the same in Prolog and Epilog. So i'm not wrong this should als...
- Tue Aug 22, 2023 9:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Mirantis mandatory for PAW
- Replies: 10
- Views: 5465
Re: Mirantis mandatory for PAW
Hi there, i have a question to this Topic, we evaluate PAW at the moment and our Test/Dev enviroment got installed with Docker CE Runtime. It took some time to get it working (Windows Server 2019) but its working and i can't catch any issues so far. Is there a reason why we should use Mirantis inste...
- Tue Aug 22, 2023 9:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use Sandbox in process
- Replies: 2
- Views: 1424
Use Sandbox in process
Hi there, my brain may be still on Holiday, but i run into a issue today, i try to do some calculations with 2 Cubes and a Sandbox, i want to get a Number from Cube A and multiplicate it with a value from Cube B, both should use the same Sandbox for those calculations. so i added a Parameter to the ...
- Tue Jun 06, 2023 3:58 pm
- Forum: Free And Open Source Tools
- Topic: .Net C# Library for TM1
- Replies: 2
- Views: 25470
Re: .Net C# Library for TM1
Wow thats nice thanks for sharing!
I will try to get into in the next days, i started also to write a c# wrapper but didn't find the time to polish it..
Do you host the source on git? Would love to contribute to the project
BR
I will try to get into in the next days, i started also to write a c# wrapper but didn't find the time to polish it..
Do you host the source on git? Would love to contribute to the project

BR
- Tue Jun 06, 2023 8:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pafe/PAX not showing Cubes
- Replies: 1
- Views: 1289
Pafe/PAX not showing Cubes
Hello Experts, we are starting to use Planning Analytics Workspace and also wanted to try out PafE/Pax, but i have an issue and cannot find the answer. I'm connected to my PA instance over PAW, but the "Sidebar" is still empty, i added an exploration to the sheet but still its empty. pafe....
- Wed Jan 25, 2023 10:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW installation - using IIS Reversed Proxy
- Replies: 2
- Views: 1928
Re: PAW installation - using IIS Reversed Proxy
Hi, thanks for your insight, you are right, i also specified the PAW Port cause when just specified the Proxy Port i got the Error Message that- "The PMHub service parameter was not specified or is not one of the configured locations." In the Dev console i can see the message " The UR...
- Tue Jan 24, 2023 11:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW installation - using IIS Reversed Proxy
- Replies: 2
- Views: 1928
PAW installation - using IIS Reversed Proxy
Hi all, we finally updated our Environment to use PAW, so it's my first time install PAW and everything was very straight forward, I switched the http and https port cause we running IIS (windows Server 2019). Works fine so far, i configurated the IIS with a reversed Proxy rule to the PAW Port,but a...
- Mon Sep 19, 2022 8:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Log to SQL DB - IPFTEST-006 - JDBC Driver Location?
- Replies: 0
- Views: 2597
TM1 Log to SQL DB - IPFTEST-006 - JDBC Driver Location?
Hi, i tried to setup the Log to our SQL DB (at the moment we just used the Filelog), so I configured the Cognos Configuration correctly but i always get the error "[ ERROR ] IPFTEST-006" .. " The error encountered is "No suitable driver found for jdbc:sqlserver:...." I'm won...
- Sun Nov 14, 2021 2:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 CAM Login not possible after CA Update
- Replies: 1
- Views: 7217
TM1 CAM Login not possible after CA Update
Hello Community, i have a problem, we updated CA from 11.0.13 to 11.2.1, after the update CA works normally, we can use the SSO and all functions are working. In TM1 is no login possible, i got this message in Architect: " SystemServerClientNotFound " In the TM1 Logs i can see this: "...
- Wed Nov 03, 2021 7:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CAM ID - How to change LDAP infos without new CAMID
- Replies: 2
- Views: 7501
Re: CAM ID - How to change LDAP infos without new CAMID
Sorry, I don't know how to keep from having to create new users but I can tell you that private views and subsets are kept in a folder under the Data directory with the same name as the value of the }TM1_DefaultDisplayValue attribute of the }clients dimension. If you can save this value and then ju...
- Wed Nov 03, 2021 3:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CAM ID - How to change LDAP infos without new CAMID
- Replies: 2
- Views: 7501
CAM ID - How to change LDAP infos without new CAMID
Hi, its not directly a TM1 question, but i hope its ok to post it here.. In our company we use ApacheDS as LDAP for Cognos CA and use CAM security to sso into TM1. Now our company has some changes in the unit structure and we want to correct namings and Unit Numbers in the LDAP, this ends with a new...
- Fri Jun 25, 2021 10:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Help Needed - MDX Dynamic Subset based on Cubevalues
- Replies: 3
- Views: 4997
Re: Help Needed - MDX Dynamic Subset based on Cubevalues
Is the Jahre dimension in the title element of the cube that you are using this subset in? If so you can use CurrentMember to filter the Jahre dimension. And then you can use StrToMember combined with the intrinsic properties to find it in the Tag dimension also. {Filter( {TM1FILTERBYLEVEL({ DESCEN...
- Thu Jun 24, 2021 1:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Help Needed - MDX Dynamic Subset based on Cubevalues
- Replies: 3
- Views: 4997
Help Needed - MDX Dynamic Subset based on Cubevalues
Hello Community, i got stuck in a mdx statement, first the MDX Code: {Filter( {TM1FILTERBYLEVEL({ DESCENDANTS(Planungseinheit.[Leistungsspektrum]) }, 0)}, [Mengen-Planung Tag Mandant].([Mengen].CurrentMember, [Kontaktart].CurrentMember, [Version].CurrentMember, [Planungseinheit].CurrentMember, [Mand...
- Tue Feb 16, 2021 8:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Dynamic Subset with Value from other Cube
- Replies: 4
- Views: 4721
Re: MDX Dynamic Subset with Value from other Cube
Hi,
Edit:
Worked, i missed that the 1 Values in this cube has a weighting so i have to change the ">1" to a "=0" and your statement worked perfectly
Thank you so much for your help!
Edit:
Worked, i missed that the 1 Values in this cube has a weighting so i have to change the ">1" to a "=0" and your statement worked perfectly
Thank you so much for your help!
- Tue Feb 16, 2021 5:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Dynamic Subset with Value from other Cube
- Replies: 4
- Views: 4721
Re: MDX Dynamic Subset with Value from other Cube
Oh nice i see if i put them up and reload it loads the subset, thank you! But one other thing it just shows me everything above the 0 Level but i just want to see the 0 level elements. { Filter({ TM1FILTERBYLEVEL({ [GuV Gliederung].[GuV Gliederung].Members}, 0) },[GuV Gliederung Attribute].([Jahre]....