Search found 200 matches

by EP_explorer
Tue Mar 12, 2024 7:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5125

Re: Ultimate Long TM1 quiz

1. Blue font - input data in space of user but not confirmed in TM1 server (another user will see another data) 2 Green font - first input data (it is even not in space of user yet) 3 Black font - confirmed data in TM1 sever (not changed in the Tm1Web) 4 Bold font - consolidation 5 White fill - fiel...
by EP_explorer
Tue Mar 05, 2024 11:44 am
Forum: Enhancements
Topic: PickList to show Alias but store Element Name
Replies: 19
Views: 105144

Re: PickList to show Alias but store Element Name

Try: subset:DIMENSION:SUBSET<StoreAlias=F> as picklist definition. Found this way in TM1 quiz, tried, but don't understand delight i.e. user put alias name from PickList, after it refresh and see code instead of alias name and ask you - where is my name which i have inputed? if user see alias name ...
by EP_explorer
Mon Dec 11, 2023 9:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut doesn't work
Replies: 11
Views: 16661

Re: ViewZeroOut doesn't work

What version is this on https://www.ibm.com/support/pages/flash-viewzeroout-function-fails-without-error It seems you are right Version is 9.0.4 Thank you Why are you using a 3 year old version? One client uses it Actually (not in the case) but in general - I don't like migrate to new version becau...
by EP_explorer
Mon Dec 11, 2023 9:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut doesn't work
Replies: 11
Views: 16661

Re: ViewZeroOut doesn't work

Sorry
Planning Analytics 2.0.9.4 of course
))
by EP_explorer
Sat Dec 09, 2023 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut doesn't work
Replies: 11
Views: 16661

Re: ViewZeroOut doesn't work

burnstripe wrote: Sat Dec 09, 2023 10:38 am What version is this on
https://www.ibm.com/support/pages/flash ... hout-error
It seems you are right
Version is 9.0.4
Thank you
by EP_explorer
Sat Dec 09, 2023 10:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut doesn't work
Replies: 11
Views: 16661

Re: ViewZeroOut doesn't work

01.jpg
01.jpg (113.48 KiB) Viewed 16098 times
by EP_explorer
Thu Dec 07, 2023 7:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut doesn't work
Replies: 11
Views: 16661

Re: ViewZeroOut doesn't work

I even at the end put detail elements in all dimensions. And result is the same. ViewZeroOut doesn't work.

Is is ppssible that cube in some way is corrupted?
by EP_explorer
Thu Dec 07, 2023 3:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut doesn't work
Replies: 11
Views: 16661

ViewZeroOut doesn't work

Found one very strange thing in one TM1 model I can't zero any view in one Cube in it using ViewZeroOut. I've done different things - at the end I deleted all rules from cube and put in view only detail elements. But ViewZeroOut doesn't work again CellPutN works, I can put 0 by hands but ViewZeroOut...
by EP_explorer
Wed Nov 29, 2023 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Searching Transaction Log and memory consumption
Replies: 0
Views: 12984

Searching Transaction Log and memory consumption

I found strange (for me) thing. Then I start searching in Transaction Log Architect->TM1 Server(right click of mouse)->View Transanction Log->(define view in Cube for searching)->OK Consumption of memory of TM1 Server growth drammatically (like it was 2Gb and after 1 minutes of searching it has 20 G...
by EP_explorer
Thu Aug 10, 2023 9:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Filter doesn't see value Calculation by CalculatedCount
Replies: 3
Views: 817

Re: MDX Filter doesn't see value Calculation by CalculatedCount

Yes. You are right. Without example it is difficult to understand the problem So I have a dimension with zeroweight elements (left on picture). Cube in which I have flags (in the middle) and MDX which have to filter CFR dimension based on Sum element (90000000000). As 90000000000 contains 0 so filte...
by EP_explorer
Wed Aug 09, 2023 1:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Filter doesn't see value Calculation by CalculatedCount
Replies: 3
Views: 817

MDX Filter doesn't see value Calculation by CalculatedCount

I have a dimension and some elements in it have 0 weight But I have to use Value of a Cube with the dimension in MDX Filter Filter(dim_for_filter,Cube(...,[dimension].[sum_element consolidated elements with 0 weight])>0) As I receive 0 on element [sum_element consolidated elements with 0 weight] I d...
by EP_explorer
Fri Jul 14, 2023 3:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX - Excel calculation based on Dynamic Report (Active Form)
Replies: 6
Views: 1130

Re: PAX - Excel calculation based on Dynamic Report (Active Form)

Thank you it helped May be you know another workarounds except offset ? In some places write that it is resource consuming The other question I guess is does sheet1 need be linked to sheet2 like this. I.e. What's stopping sheet1 from also being a dynamic report sharing the same filters as sheet2? T...
by EP_explorer
Fri Jul 14, 2023 3:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX - Excel calculation based on Dynamic Report (Active Form)
Replies: 6
Views: 1130

Re: PAX - Excel calculation based on Dynamic Report (Active Form)

WilliamSmith wrote: Thu Jul 13, 2023 5:54 pm You can try using Indirect() and passing in the cell reference as a string.
Yes
It works as well
Thank you
by EP_explorer
Thu Jul 13, 2023 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX - Excel calculation based on Dynamic Report (Active Form)
Replies: 6
Views: 1130

Re: PAX - Excel calculation based on Dynamic Report (Active Form)

Thank you
it helped

May be you know
another workarounds except offset?

In some places write that it is resource consuming
by EP_explorer
Wed Jul 12, 2023 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX - Excel calculation based on Dynamic Report (Active Form)
Replies: 6
Views: 1130

PAX - Excel calculation based on Dynamic Report (Active Form)

I'm trying to make some calculation in Excel based on data from Dynamic Report (which using MDX filtering in it) So at first step I open Dynamic Report (Active Form) which shows data on Sheet2 and make simple link from column J to Sheet1 column A It seems works 01.JPG After it I make filtering in Dy...
by EP_explorer
Tue Apr 25, 2023 10:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about Cognos Analytics Audit Security
Replies: 0
Views: 10892

Question about Cognos Analytics Audit Security

I understand that the such sort of questions is not completely the right place but may be you give me some ideas or give me piece of advice where can I ask my question Anayway our PAL installation using CAS groups and user from Active Directory I want to know who from admins in Cognos Analytics and ...
by EP_explorer
Thu Nov 24, 2022 8:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it possible in PAW do the same thing as I can do in PAX (go through from one view to another) on
Replies: 3
Views: 667

Re: Is it possible in PAW do the same thing as I can do in PAX (go through from one view to another) on

Thank you Idea with Drill came into my mind But it has one defect -Drill appears in new pop-up window which impossible to manage (for example I want to add in the new pop-up window the button which run process or return in previous tab) Example in PAX looks more convenient. May be something like tha...
by EP_explorer
Wed Nov 23, 2022 1:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it possible in PAW do the same thing as I can do in PAX (go through from one view to another) on
Replies: 3
Views: 667

Is it possible in PAW do the same thing as I can do in PAX (go through from one view to another) on

The example is taken from TM1 Official Guide I put Cursor in the cell of Travel row (Cube1) 01.JPG Click the Button Go To Details List appears (Cube 2 Appears with the same dimensions + 1 dimension of rows). And it shows the same Travel element in Context 02.JPG It is made by Advanced Options of Act...
by EP_explorer
Mon Mar 22, 2021 11:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Expression based on Cube Value
Replies: 2
Views: 1645

Re: MDX Expression based on Cube Value

Yes It works
Thank you a lot
by EP_explorer
Mon Mar 22, 2021 11:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Expression based on Cube Value
Replies: 2
Views: 1645

MDX Expression based on Cube Value

I have dimension Version with elements
Version 1
Version 2
Version 3

And Cube1 with 2 dimensions
Dim1 (with element El1)
Dim2 (with element El2)

In Cube1 I input value
Version 2

How I can write mdx expression for subset in dimension Version which contain input value in Cube1 (in our case Version 2)