Search found 120 matches

by HighKeys
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...
by HighKeys
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'] ) ;
by HighKeys
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...
by HighKeys
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...
by HighKeys
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...
by HighKeys
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...
by HighKeys
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...
by HighKeys
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 ...
by HighKeys
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
by HighKeys
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....
by HighKeys
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...
by HighKeys
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...
by HighKeys
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...
by HighKeys
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: "...
by HighKeys
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...
by HighKeys
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...
by HighKeys
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...
by HighKeys
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...
by HighKeys
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!
by HighKeys
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]....