Search found 66 matches

by babytiger
Wed Sep 19, 2018 12:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Save the rights of a Contributor Application via TI
Replies: 8
Views: 241

Re: Save the rights of a Contributor Application via TI

The security cubes I've mentioned in my post behaves the same way as other security cubes in TM1. So, you can apply rules to those cube if you want. Just need to make sure you trigger a security refresh after update of approval dim. Because ruled security doesn't take effect straightaway, it is diff...
by babytiger
Wed Sep 19, 2018 12:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Question
Replies: 2
Views: 186

Re: MDX Question

In your MDX example, TM1FILTERBYPATTERN is not doing anything, since you don't have a wildcard (*) in your criteria. If what you wanted is just to specify, months (M01 to M12), then bring through all the children/leaf elements, then this may help: {TM1FILTERBYLEVEL( {DESCENDANTS( {[Period].[M01],[Pe...
by babytiger
Mon Sep 17, 2018 7:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Question of the day
Replies: 9
Views: 320

Re: TM1 Question of the day

Someone who has the time to play around with it ? :D 5 minutes can always be donated :lol: A TI process with a dynamic level 0 subset as the data source, and the Metadata inserting an N-level element in the dimension, will have the Data tab including this new element. Anyone who can test in a diffe...
by babytiger
Sun Sep 16, 2018 11:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Question of the day
Replies: 9
Views: 320

Re: TM1 Question of the day

That's really interesting. I wondered if this is a version specific functionality.
by babytiger
Thu Sep 13, 2018 11:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Save the rights of a Contributor Application via TI
Replies: 8
Views: 241

Re: Save the rights of a Contributor Application via TI

Yes, you can refresh/save rights of a Contributor Application via TI. I've done that for a few contributor apps for multiple clients. 1. You need to find out which apps (assuming you have multiple apps that use different approval dim/subsets). You can get all the info via "}tp_applications". It shou...
by babytiger
Thu Aug 30, 2018 3:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a }Picklist cube in a TI process
Replies: 3
Views: 122

Re: Creating a }Picklist cube in a TI process

Have you tried unloading picklist target cube, and then reload the target cube (create a one cell cube view and access it).

Suspect there is a cube dependency on picklist cubes. Destroying the picklist cube may have removed this dependency.
by babytiger
Wed Aug 29, 2018 12:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reports against TM1 - Question
Replies: 4
Views: 242

Re: Reports against TM1 - Question

This is a fairly common scenario for a TM1 reporting cube, whether is reported from BI or other reporting tools such as Perspectives. Here is what I would do: All calculations is done in TM1 cube. Introduce another Account Attribute [1, -1] in TM1 that refers to the Revenue/Expenses attribute. This ...
by babytiger
Wed Aug 22, 2018 5:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Cube Design for a Financial Model
Replies: 6
Views: 414

Re: Best Cube Design for a Financial Model

If user usability outweighs performance, then I would be more incline to go with multiple cubes. DBRW formulas on perspective would be shorter, since you don't have to select those non-relevant dimensions for a cube. Users can still reference multiple cubes on the same sheet, (but it is more difficu...
by babytiger
Wed Aug 22, 2018 5:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Cube Design for a Financial Model
Replies: 6
Views: 414

Re: Best Cube Design for a Financial Model

I guess you would have evaluate the pros and cons of each method: Separate cube pros: less sparse cubes easier to rule and feed easier for user consumption (fewer dimensions to select from) cons: may require more TIs for data load or export may introduce reconciliation issues (as one GL combining P&...
by babytiger
Tue Aug 21, 2018 11:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest API to get the top level elements
Replies: 6
Views: 469

Re: TM1 Rest API to get the top level elements

In your original post, you've asked for a rest query that returns the top level elements of a dimension. Top level means those elements without any parent, or have I missed something? In the example you've given, the only 2 elements that do not have any parent are S19 and G0. Because A0 P0 and A1 al...
by babytiger
Tue Aug 21, 2018 7:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest API to get the top level elements
Replies: 6
Views: 469

Re: TM1 Rest API to get the top level elements

For the dimension structure you have just created, what did the api code return? Isn't it giving you the 5 elements that you've mentioned? With regards to your other question, I would like to point you to the IBM TM1 Rest API guide: https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/kc_gen...
by babytiger
Tue Aug 21, 2018 12:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest API to get the top level elements
Replies: 6
Views: 469

Re: TM1 Rest API to get the top level elements

Filter by Parents, where count of parent =0. /api/v1/Dimensions('Dimension')/Hierarchies('Dimension')/Elements?$filter=Parents/$count eq 0 Alternative is, create a dynamic subset, and have the rest api refer to the subsets [workaround]. Edit: Also I would suggest that you update the Subject of your ...
by babytiger
Mon Aug 20, 2018 11:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?
Replies: 9
Views: 886

Re: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?

If I understand your issue correctly... 1. don't want to pay for extra licensing costs, hence distributing excel workbooks to users via email. 2. would like to retain the excel formulas on workbook, so any changes can be fed back to TM1 when you response with updated workbook. but this causes issues...
by babytiger
Tue Aug 07, 2018 6:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTRow with MDX Expression that Returns zero elements
Replies: 8
Views: 536

Re: TM1RPTRow with MDX Expression that Returns zero elements

I would check the composed MDX statement. Sounds like the MDX expression built from your list of dropdowns may be incorrect. I would suggest take a copy of your websheet, remove the active forms section, and output the MDX that you use for the TM1RptRow to a cell, and copy it to Subset Editor to val...
by babytiger
Tue Aug 07, 2018 5:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to deploy application in performance modaller
Replies: 2
Views: 262

Re: Unable to deploy application in performance modaller

Using a shared cube for multiple application is fine for PM, provided that the same cell (in the shared cube) is only writable in one application. Hence the suggestion of using a Control Dimension, such as Version. I don't know how you've structured your applications, app A & B. So I am using a scen...
by babytiger
Mon Feb 13, 2017 10:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web Deployment
Replies: 7
Views: 945

Re: TM1 Web Deployment

aravind.cgns wrote:I have a requirement where i have to access my Control Cubes and TI Process from performance modeler in TM1 web.
This doesn't make sense. They both are clients of TM1, and I don't think they walk to each.
by babytiger
Mon Feb 13, 2017 10:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question for Asciioutput
Replies: 13
Views: 1944

Re: Question for Asciioutput

Hi and what if there are two measures, Measure1 = 100, Measure2 = -100 Then zero suppression will exclude it from the view because the total is 0 (at least my assumption is that if a cell is rule calculated, but fed, but the value itself is 0, then it will be suppressed? let me know if I am wrong, ...
by babytiger
Thu Oct 20, 2016 10:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bringing numeric cell value as it is from the database
Replies: 9
Views: 951

Re: Bringing numeric cell value as it is from the database

I feel you are coming from a wrong angle here. I don't see a valid reason for getting TM1 to dictate a file to meet your DB's requirements. IMO, I think the file should contain data that matches exactly to TM1, without further massaging on the formatting and precision. In this case, NumberToString m...
by babytiger
Thu Oct 20, 2016 10:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StringToNumber does not use locale decimal delimiter
Replies: 8
Views: 1470

Re: StringToNumber does not use locale decimal delimiter

I tend to use NUMBR function for converting strings to numbers. The string you want to convert to a number. All characters other than '0' through '9', '+', '-', '.', and 'E' are ignored. The risk with this function is, if for some reason that one of your user decided to set the locale differently, e...
by babytiger
Wed Oct 19, 2016 6:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PR to DR synchronization of Data
Replies: 7
Views: 966

Re: PR to DR synchronization of Data

Depending how big is your TM1 server instance. My personal opinion is, taking the entire data folder to DR would minimise the risk of missing data for certain objects. If you server instance is large (taking a long time to start), then the chances are it will take a long time to sync your data acros...