Search found 105 matches

by Elessar
Wed Jan 17, 2018 7:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Alias update and stargate view
Replies: 5
Views: 253

Re: Alias update and stargate view

I think updating an alias (like updating a rule) will purge all the affected stargates: rules use element aliases, so the calculated data may change after the "alias update". You can turn ON the stargate logging and see how "alias changing" affects the stargates. Sachin has described the stargate lo...
by Elessar
Mon Dec 18, 2017 7:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sigle Sign On TM1
Replies: 5
Views: 304

Re: Sigle Sign On TM1

What about the 2nd question? Does this error occur on BI portal (server.domain.com/ibmcognos)?
by Elessar
Thu Dec 14, 2017 1:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sigle Sign On TM1
Replies: 5
Views: 304

Re: Sigle Sign On TM1

Hi,

1. What do you mean by " single sign is not working"? The login window appears? Is there any errors?
2. Does this error occur on BI portal (server.domain.com/ibmcognos)?
by Elessar
Thu Dec 14, 2017 9:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionSecurity Rules not being fired
Replies: 14
Views: 669

Re: DimensionSecurity Rules not being fired

tony.wijaya,

This is really strange. You can use the audit log to determine the culprit
by Elessar
Tue Dec 12, 2017 10:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Always Expanded Workflow Approval Hierarchy?
Replies: 1
Views: 360

Re: Always Expanded Workflow Approval Hierarchy?

Hello all!

I need this option also :) As far as I know, we cannot force the approval hierarchy to be shown expanded by default.
But I can create RFE for this. Will it be popular?
by Elessar
Wed Dec 06, 2017 2:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: carry forward a dimension elements to another dimension
Replies: 5
Views: 329

Re: carry forward a dimension elements to another dimension

If you understand you right, bedrock.dim.clone with pUnwind=2 will solve your task:
https://github.com/cubewise-code/bedroc ... .Clone.pro
by Elessar
Wed Nov 15, 2017 8:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue updating TM1 Application (Contributor) Rights (Cognos TM1 10.2.2)
Replies: 1
Views: 291

Re: Issue updating TM1 Application (Contributor) Rights (Cognos TM1 10.2.2)

Hello and welcome to the forum! It's strange that a topic with such a good problem description is still not answered :) Try to "redeploy" contributor: stop appserver, delete all "<server name="s in fpmsvc_config.xml, start appserver, open server:port/pmpsvc/ page and add your server with 5th integra...
by Elessar
Fri Oct 27, 2017 10:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 upgrade to Planning Analytics
Replies: 3
Views: 241

Re: TM1 upgrade to Planning Analytics

Hello! Note that TM1 ver. >= 10.2.0 uses Open XML file formats for Microsoft Excel worksheets. There is utility to convert you websheets, but it could'nt convert 20% of my websheets, so I had to recreate them. https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_ins...
by Elessar
Fri Oct 27, 2017 7:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom Workflow
Replies: 10
Views: 528

Re: Custom Workflow

So, what's the question? You need a multidimensional workflow with BU, Year and Version dimensions? If so, you can make independent BU workflows using Years as control dimension: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.prfmdl_ug.2.0.0.doc/t_tm1_definingacont...
by Elessar
Wed Sep 27, 2017 10:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 11
Views: 718

Re: Dynamic subset based on a cube value, with another dimension

st2000,

Do you mean that "DeptSlicer"'s elements will be department dimension's names?
If so, I don't understand how this can help me, could you please provide more details? I still can not refer to Department dimension from Product's MDX.
by Elessar
Fri Sep 22, 2017 8:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 11
Views: 718

Re: Dynamic subset based on a cube value, with another dimension

rafaewolie, I want to use MDX in Product dimension's subset In details: 1. I have a mapping cube with dimensions: Department1, Product, Measures , where I can set NxN mapping for departments and products. I can use this mapping for creating a dynamic subset in Product dimension in any cube view with...
by Elessar
Tue Sep 19, 2017 9:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it possible to purge a stargate view?
Replies: 4
Views: 246

Re: Is it possible to purge a stargate view?

Hello, You can unload the cube by 2 ways: Right-click on the cube in Architect, "Unload cube" Use "CubeUnload(CubeName);" TI function When you change VMM/VMT, the stargate view does disapear, but the calculation cache remains You can find the details in Sachin's blog: https://everanalytics.wordpress...
by Elessar
Tue Sep 19, 2017 7:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation values by User Access
Replies: 3
Views: 259

Re: Consolidation values by User Access

Then yours is 3rd option: You can write the excel SUM (..) formula, so it will calculate only the available projects
by Elessar
Mon Sep 18, 2017 1:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 11
Views: 718

Re: Dynamic subset based on a cube value, with another dimension

Thanks Drg, This will not help. The problem is because "dimension in a mapping cube" and "dimension in context of budget cube view" are equal, but different (Dep1 and Dep2). When you filter by a cube value in MDX, you do not specify the elements of coincident dimensions (like !Dim in DB). But the di...
by Elessar
Mon Sep 18, 2017 1:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation values by User Access
Replies: 3
Views: 259

Re: Consolidation values by User Access

Hello!
  • Create alternative hierarchies for each user group
  • Add a dimension which describes user group (e.g. Department?)
  • Write Excel formula (SUM)
by Elessar
Mon Sep 18, 2017 10:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 11
Views: 718

Dynamic subset based on a cube value, with another dimension

Hello all, I have 2 dimensions with N*N mapping: "Department 1" and "Product". Mapping.png For the views with "Department 1" in context and "Products" in rows, I can use the following MDX query for "Products" dynamic subset: {FILTER({TM1SUBSETALL( [Product] )}, [Mapping Product - Department].([Measu...
by Elessar
Fri Sep 15, 2017 8:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wrap alias in TM1 Web view
Replies: 6
Views: 755

Re: Wrap alias in TM1 Web view

Tom,
I agree it's a hack, but changing *.css files in TM1 10.1.* is encouraged by IBM: http://www-01.ibm.com/support/docview.w ... wg21634684

Note that changing .css files in PA is prohibited (also, CSSs in PA are built into compressed files and not so easily changeable)
by Elessar
Wed Sep 13, 2017 1:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planing Analytics and CAM Security
Replies: 7
Views: 621

Re: Planing Analytics and CAM Security

Chris, did this help?
by Elessar
Fri Sep 08, 2017 8:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planing Analytics and CAM Security
Replies: 7
Views: 621

Re: Planing Analytics and CAM Security

So, you've configured IIS gateway for CA? Did you copy the tm1 folder and planning.html from webcontent to webcontent/bi? Here is the second guide about PA+CA integration (published yesterday), hope this will help https://www.ibm.com/communities/analytics/cognos-analytics-blog/cognos-analytics-and-p...