- question20.JPG (71.6 KiB) Viewed 48 times
Search found 204 matches
- Mon May 20, 2024 9:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15134
- Thu May 16, 2024 9:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15134
Re: Ultimate Long TM1 quiz
As we have to feed ‘a’ all the time (4 is unchanged) so
add new cube with input value, or element 'c' - input all values in it (1 for example)
and
[‘c’] => [‘a’];
- Fri Apr 12, 2024 11:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Button - Process Failed - with No Log
- Replies: 6
- Views: 1411
Re: Action Button - Process Failed - with No Log
May be user doesn't have rights for the process.
In this case I see the same behaviour
User clicks on button, see error window and nothing in log file
In this case I see the same behaviour
User clicks on button, see error window and nothing in log file
- Fri Apr 05, 2024 11:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15134
Re: Ultimate Long TM1 quiz
Nice last question ))
Especially about the cat
MDX
- in subsets (MDX subset you can create in Subset Editor - expression window or during the TI process - SubsetCreatebyMDX)
- in MDX views (in PAW and PAX - Edit MDX in menu)
Especially about the cat
MDX
- in subsets (MDX subset you can create in Subset Editor - expression window or during the TI process - SubsetCreatebyMDX)
- in MDX views (in PAW and PAX - Edit MDX in menu)
- Tue Mar 12, 2024 7:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15134
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...
- Tue Mar 05, 2024 11:44 am
- Forum: Enhancements
- Topic: PickList to show Alias but store Element Name
- Replies: 19
- Views: 109166
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 ...
- Mon Dec 11, 2023 9:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewZeroOut doesn't work
- Replies: 11
- Views: 16927
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...
- Mon Dec 11, 2023 9:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewZeroOut doesn't work
- Replies: 11
- Views: 16927
Re: ViewZeroOut doesn't work
Sorry
Planning Analytics 2.0.9.4 of course
))
Planning Analytics 2.0.9.4 of course
))
- Sat Dec 09, 2023 11:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewZeroOut doesn't work
- Replies: 11
- Views: 16927
Re: ViewZeroOut doesn't work
It seems you are rightburnstripe wrote: ↑Sat Dec 09, 2023 10:38 am What version is this on
https://www.ibm.com/support/pages/flash ... hout-error
Version is 9.0.4
Thank you
- Sat Dec 09, 2023 10:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewZeroOut doesn't work
- Replies: 11
- Views: 16927
- Thu Dec 07, 2023 7:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewZeroOut doesn't work
- Replies: 11
- Views: 16927
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?
Is is ppssible that cube in some way is corrupted?
- Thu Dec 07, 2023 3:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewZeroOut doesn't work
- Replies: 11
- Views: 16927
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...
- 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: 14476
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...
- 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: 862
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...
- 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: 862
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...
- 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: 1196
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...
- 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: 1196
Re: PAX - Excel calculation based on Dynamic Report (Active Form)
YesWilliamSmith wrote: ↑Thu Jul 13, 2023 5:54 pm You can try using Indirect() and passing in the cell reference as a string.
It works as well
Thank you
- 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: 1196
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
it helped
May be you know
another workarounds except offset?
In some places write that it is resource consuming
- 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: 1196
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...
- 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: 10994
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 ...