Search found 70 matches

by babytiger
Thu Oct 04, 2018 7:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process - Meta Data Behavior
Replies: 2
Views: 151

Re: TI Process - Meta Data Behavior

If you want to stick with csv, then I would suggest getting the source file tidied up, as I believe the csv file is not correctly created. In the scenario you've shown, if correctly formatted in csv, it should be "126", "Lance, Christopher" ,"Christopher","Lance","137","systemanalyst","","abc","104...
by babytiger
Fri Sep 28, 2018 12:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Postman] Unexpected token : yes but where ?!
Replies: 9
Views: 246

Re: [Postman] Unexpected token : yes but where ?!

I am not very familiar with Postman, but should your JSON payload not be in the body? Pre-request script should be Javascript code. Yes, in this case, the MDX query statement should be part of "Body". Is TM1 so difficult for newbies ? I have worked for 15 years on webapps and Java developments... I...
by babytiger
Mon Sep 24, 2018 6:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Save the rights of a Contributor Application via TI
Replies: 12
Views: 771

Re: Save the rights of a Contributor Application via TI

Sorry if my original post was a bit brief and/or confusing. Just want to clarify a couple of things: TI: }tp_deploy_create_shadow_dimension - This TI replicates your ApprovalDim to a shadow dimension, eg. }tp_task}....... This TI doesn't have anything to do with security. TI: }tp_rights_update_RDCLS...
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: 12
Views: 771

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: 282

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: 483

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: 483

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: 12
Views: 771

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: 198

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: 313

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: 506

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: 506

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: 549

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: 549

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: 549

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: 10
Views: 1440

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: 671

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: 294

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: 1016

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.