TM1 Forum

Thanks Lotsaram.
Fresh set of eyes fixed the issue. There was one dimension missing in my rule. Your pointing to basics made me check.

Thanks,
Paul.

Hi, I need help with a rule. ['Hours'] =N: if ( attrs( 'Versions', 'Forecast', 'LiveVersion') @='Y' & !Companies @= attrs ( 'Employees' , !Employees, 'EmplGroup' ) & !PLC @= DB('Labor-ASDF',!Employees,!Months,!Projects,!Versions,'PLC') , DB('Labor-ASDF',!Employees,!Months,!Projects,!Versions...

Thanks Declanr.
I too found it the hard way yesterday. ItemSkip works only in the metaData or Data tabs.
I too applied the same logic you sent. Thanks again.

Paul.

Hi, I am working on version 2.1.14 and found a strange issue that ItemSkip is not skipping a record, but coming out of the while loop. I have pasted the code below. The moment 'Factor' is hit, it's coming out of the loop. I ran the same code in on our old server - 2.0.92 and found it does the same -...

Hi, I am trying to get accountability setup in the PA 2.1.14. This is new enhancement and when I look at the implementation details in the documentation, I am unable to comprehend where the Database settings tab is in the plan page. Can someone help me? Procedure On the plan page, go to the Database...

Thanks Adam.

Hi All, We have 3 AD Groups and the security works for the most part. When I say working, we have our security rules on the projects dimension and all users get the projects based on their AD group - which is working in PAW. In PAW Websheets are not refreshing for 2 AD groups but refresh for 1 AD gr...

Hi All,
Can we add Groups to PAW Applications instead of Users.

Thanks,
Paul.

Hi All, Has anyone seen this problem? I installed a new version of Docker/ Mirantis yesterday and I get an error when I configure PAW. I was installing Docker on a 2016 server. PAW version ipa_workspace_win_2019_2.1.14.258. What should my next steps be? where should the license file be placed on the...

Thanks Burnstripe.
I was curious if it's possible. We currently publishTM1 applications (contributor) into Cognos and thought it could be possible and I am new to PA 2.1.

Thanks,
Paul.

Hi all, 1. Can we publish PAW Applications from PAW to Cognos Analytics? I have searched and did not find anything. 2. While searching for the first question, I found that we can publish from PAX to Cognos Connection and I don't see a way for that. How is the connection set up? Can someone please se...

That helps. Thanks Ascheevel!

Hi Wim, We are transitioning from Contributor to PAW next month. In between, I want to expose the PAW views (input screens) to all the users for a month. This will give us time to fix the issues and fully upgrade. So, technically, we will be using 2.0.9.2 for a month and Contributor is still present...

Hi all,
Is there a parameter that would not allow data input at consolidation level in Contributor? How can this be achieved?

Thanks,
Luther.

Hi Wim,
Thanks for replying.
Saving the subset without the name seemed to help the day1, but when we opened the next day, or added the subset to another view, the name appears.
The list in the subset is created using MDX and I am looking for a MDX solution.

Thanks,
Paul.

Thanks Lotsaram. In the set editor in PAW, in the dropdown of caption when I select member Id, member ID is displayed. I saved the subset thinking it would keep the member Id, but it's not. When open the subset, alias is back. Any idea on what should be done to just get the member Id from the MDX? T...

Thanks Maren, it did not help.

"2 - FPA" is not an alias. It's ID.

Again, I want to remove name that comes with alias in the list after committing MDX.

Thanks,

Paul.

Hi All, By default, when a dimension is opened, alias with name is coming and am trying to remove. In PAW, I was able to select "Member ID" from dropdown and it's static thought I saved. When I reopened the subset, the alias turned on. What MDX should be added to remove alias. I am sure th...

Thanks for your inputs Tomok and Burnstripe.
Let's say we have a web server what components can we put on it to add PAW server configuration?

Thanks,
Paul.

Hi All, We are upgrading from 2.0.9 to 2.1 and need help in getting the server requirements right. We currently have 3 servers in 2.0.9 and use contributor for data entry. PAW for reporting and analysis. Current Landscape: 1. App server --> where the TM1 admin server and all the databases (TM1 serve...