TM1 Forum

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

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)

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...

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 ...

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...

Sorry
Planning Analytics 2.0.9.4 of course
))

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

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?

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...

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...

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...

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...

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...

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

Thank you
it helped

May be you know
another workarounds except offset?

In some places write that it is resource consuming

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...

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 ...

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...

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...