Search found 795 matches

by paulsimon
Sat Sep 11, 2021 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CELL STATUS
Replies: 4
Views: 2254

Re: CELL STATUS

Hi Micheline To the best of my knowledge, there is no way to do that in an Active Form, unless you resort to VBA, which has never been an option for me as all sheets are deployed as Web Sheets in TM1 Web or PAW. However, if you understand the rules and security on the cube, you can normally predict ...
by paulsimon
Wed Sep 01, 2021 5:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Merge Date Dimensions from different servers
Replies: 6
Views: 2732

Re: Merge Date Dimensions from different servers

Hi A possible solution is Add a Web Sheet to the PAW book Sync to the Date Dimension on that. Put a SUBNM on that for the Date2 Dimension where the element parameter references the currently selected Date Dimenstion element's SUBNM Sync your other PAW Grid that uses the Date2 Dimension to the Date2 ...
by paulsimon
Tue Aug 31, 2021 8:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos PA can not connect to ClickHouse via ODBC
Replies: 6
Views: 2308

Re: Cognos PA can not connect to ClickHouse via ODBC

Hi All I can suggest is checking that you have a 64 bit ODBC driver and that you have the latest driver installed. Not too sure exactly what ClickHouse is. It claims to be an OLAP database, and a Columnar database and a NoSQL database. Whichever of those it is, it is not a standard SQL relational da...
by paulsimon
Mon Aug 30, 2021 2:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos PA can not connect to ClickHouse via ODBC
Replies: 6
Views: 2308

Re: Cognos PA can not connect to ClickHouse via ODBC

Hi

Try adding one of the following to your TM1S.CFG

# UseSQLFetch=T
# UseSQLFetchScroll = T
# UseSQLExtendedFetch = T

From memory, the first is the most basic form of ODBC that should be supported.

Regards

Paul Simon
by paulsimon
Tue Jul 27, 2021 9:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Publish MDX views
Replies: 8
Views: 3793

Re: Publish MDX views

Hi Wim While what you say is true, I somehow doubt that a user is going to want to save a view in PAW, then open it in PAX, extract the MDX and paste it into the parameter area of a TI process which will then run to create the MDX view. I am guessing that the original poster already has something th...
by paulsimon
Mon Jul 26, 2021 9:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Publish MDX views
Replies: 8
Views: 3793

Re: Publish MDX views

Hi I can't say that I have tried it but if you take the MDX from the view, you should be able to pass that as a parameter to a TI process and then that can create a public MDX view. Probably easier to automate if the view is created in PAX rather than PAW. If created in PAW you would probably need t...
by paulsimon
Wed Jun 30, 2021 9:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Opinions & Best Practices for Front-end Design
Replies: 6
Views: 2745

Re: Opinions & Best Practices for Front-end Design

Hi When it comes to typing in a value and seeing the result immediately, a single user working on their own data is probably always going to get a better response from an Excel sheet. However, planning is not about working alone. We still have some users who do spreadsheet based collections and then...
by paulsimon
Thu Jun 24, 2021 6:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help Needed - MDX Dynamic Subset based on Cubevalues
Replies: 3
Views: 2613

Re: Help Needed - MDX Dynamic Subset based on Cubevalues

Hi BR Another approach that I have used is to add an attribute to the dimension Jahre eg Selected Year You can then put a rule into the }ElementAttributes_Jahre cube which sets the Attribute to Y based on some condition eg the equivalent value in the Tag dimension. Then in your MDX you can just reco...
by paulsimon
Tue Jun 08, 2021 5:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule set value to zero
Replies: 7
Views: 3198

Re: Rule set value to zero

Hi As Wim says you should continue to use rules to set values to zero to prevent data entry, but you need to tune your feeders to avoid feeding them. You can rely on security to prevent data entry. However, the issue there is that this will probably only block an end-user. It will not block an Admin...
by paulsimon
Thu May 20, 2021 10:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Months and TimePeriod
Replies: 8
Views: 4786

Re: Months and TimePeriod

Hi manu I have updated my Month Dimension Generator to include a Period Totals Named Hierarchy. This includes consolidations giving the sum of the same period across all years, and a Full Year consolidation of those periods. With this, in PAX or PAW you can use, for example, the Periods and Full Yea...
by paulsimon
Tue May 11, 2021 9:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Months and TimePeriod
Replies: 8
Views: 4786

Re: Months and TimePeriod

Hi Manu You need to create a proper Named Hierarchy, not just an alternate hierarchy. Check the TI Reference guide. Do not bother with Attribute Hierarchies. Create a Named Hierarchy, and use HierarchyElementInsert and HierarchyElementComponentAdd to build the month consolidations. Regards Paul Simon
by paulsimon
Mon May 10, 2021 9:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Months and TimePeriod
Replies: 8
Views: 4786

Re: Months and TimePeriod

Hi If you are actually on PA, then you should be able to use Named Hierarchies to do this. This is because with Named Hierarchies in a dimension you can show one Named Hierarchy on the rows and another on columns, I assume that at present, you have one dimension with months like 2020-01, 2020-02 ---...
by paulsimon
Wed Mar 10, 2021 7:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX question
Replies: 10
Views: 2005

Re: MDX question

Hi Mario If the last month with data is random then there is certainly no easy bit of MDX that will do this. However, what is the business logic here? I am guessing that period 08 is your current period and therefore you want to show all periods up to this regardless of whether they have actuals, bu...
by paulsimon
Sat Feb 20, 2021 9:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create MDX View To Suppress Rule-Defined Cells
Replies: 2
Views: 692

Re: Create MDX View To Suppress Rule-Defined Cells

Hi Adam

If you submit your MDX using the Rest API, then in the ODATA query you can retrieve something that tells you whether the cell is rule calculated. However, I do not know a way of doing it in MDX alone.

Regards

Paul Simon
by paulsimon
Wed Feb 10, 2021 11:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess Again
Replies: 14
Views: 2587

Re: RunProcess Again

Hi Pavo Thanks for confirming that your issue with locking in temporary subsets is only related to temporary subsets that are MDX based. We don't use of those. Typically our MDX subsets are for things like get all base elements or full hierarchy. These are created as permanent subsets as part of our...
by paulsimon
Wed Feb 10, 2021 8:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess Again
Replies: 14
Views: 2587

Re: RunProcess Again

Hi Pavo Interesting that you have still got locks when using temporary views and subsets. Surely creating a permanent subset is more likely to cause lock contention since that is a meta data event? If I understand you correctly, you are relying on the lock being relatively short by creating the subs...
by paulsimon
Tue Feb 09, 2021 9:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess Again
Replies: 14
Views: 2587

Re: RunProcess Again

Hi

Where possible use temporary subsets and views. This had a dramatic effect on our lock contention, not to mentioned clutter.
by paulsimon
Tue Feb 09, 2021 9:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prevent Consolidation Sums for an Element
Replies: 5
Views: 1144

Re: Prevent Consolidation Sums for an Element

Hi Charlotte It really depends on your purposes but my gut feel is that you should avoid using a string measure. If you want one measure to roll up and the other not to roll up then you can do this Have one dimension with a consolidation A B C Have a measures dimension crossed with this with two mea...
by paulsimon
Mon Feb 08, 2021 10:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess Again
Replies: 14
Views: 2587

Re: RunProcess Again

Hi Maren If you are going to use RunProcess to set off 300 lots of Process A in parallel, then you aren't going to get that degree of parallel processing unless your box has 300 processors. Therefore I would not bother about the fact that an instance of Process A will not complete until Process B fi...
by paulsimon
Thu Feb 04, 2021 7:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prevent Consolidation Sums for an Element
Replies: 5
Views: 1144

Re: Prevent Consolidation Sums for an Element

Hi Charlotte I am not sure what you are asking. If you want an element at the bottom of the hierarchy and you don't want values in this to sum up, then using a zero weight as Declan suggests is the way to go. However, if when you say the lowest level dimension, you actually mean the measures dimensi...