Search found 3503 matches

by lotsaram
Mon Sep 18, 2023 7:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export }-Cubes with Bedrock
Replies: 3
Views: 2048

Re: Export }-Cubes with Bedrock

The process }bedrock.hier.export will include all attribute names and type in the header, before the body which contains the hierarchy structure and attribute values. So if you want the attribute values it will be in that file. If you aren't interested in the structure you could always just ignore a...
by lotsaram
Mon Sep 11, 2023 8:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help on MDX
Replies: 4
Views: 697

Re: Need help on MDX

CURRENTMEMBER.PROPERTIES work fine but CURRENTMEMBER.PROPERTIES().PROPERTIES() doesn't work. And why on earth would you expect this to work? CurrentMember is obviously a member CurrentMember.Properties("propertyName") returns a string You cannot pass a string into an expression which requ...
by lotsaram
Fri Sep 08, 2023 11:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock And Github vs Other Options
Replies: 22
Views: 19754

Re: Bedrock And Github vs Other Options

The key point, THE. KEY. POINT. is that if Bedrock was still maintained entirely in house by Cubewise such that each release was an unvarying quantity that could be comprehensively tested, there would be a degree of certainty about the functionality for that version of it . As it was released into ...
by lotsaram
Wed Sep 06, 2023 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX which takes Value from Cube
Replies: 12
Views: 7042

Re: MDX which takes Value from Cube

Why would a new user with no post history necromance a thread from 6 years ago just to troll someone? Very weird stuff. Maybe it's a chatbot/trollbot?
by lotsaram
Wed Sep 06, 2023 11:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Any tm1web log setting to get user access websheet info
Replies: 6
Views: 1094

Re: Any tm1web log setting to get user access websheet info

Niko wrote: Sat Sep 02, 2023 4:59 pm I want to know websheet is opened by user how much times,but tm1web can not find these information,i am confused,anyone can help me ,thank u first.
If you are lucky enough to have Pulse, and it is properly configured then Pulse captures this information and it can be reported.
by lotsaram
Wed Aug 30, 2023 4:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mirantis mandatory for PAW
Replies: 10
Views: 1888

Re: Mirantis mandatory for PAW

WilliamSmith wrote: Wed Aug 30, 2023 12:45 pm Are you saying the long term road map is to migrate PAW away from running on Windows server?
Long term roadmap? :lol:
by lotsaram
Fri Aug 25, 2023 8:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Turn off consolidated drilling?
Replies: 4
Views: 786

Re: Turn off consolidated drilling?

Using element security is an interesting idea, I'll have to try it out. I am trying to display the top and bottom levels of a three tier hierarchy so I would just need to make sure that hiding the middle parents didn't block access to the leaves altogether. Whether this works using element security...
by lotsaram
Fri Aug 11, 2023 12:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Domain-Administrator for TM1?
Replies: 1
Views: 1062

Re: Domain-Administrator for TM1?

The main issue is access to network resources. The account running the TM1 service doesn't need to be domain admin, but the account needs to have sufficient rights to do what it needs to do, e.g. read from and write to network shared folders which are located on another machine on the network, use t...
by lotsaram
Fri Jul 28, 2023 11:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1-Web Usage of Alias for Elements
Replies: 2
Views: 817

Re: TM1-Web Usage of Alias for Elements

I think there's nothing to do here except user education.
When the users make an alternate selection by dimension for the relative spread it will launch the subset editor, and there they get the chance to apply an alias rather than the element technical names.
by lotsaram
Fri Jul 07, 2023 7:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Identify All References to Cube
Replies: 7
Views: 9807

Re: Identify All References to Cube

Or commercial tools such as Qubedocs. Note: I have no advantage of or links with, Qubedocs. Or roll your own solution by using a TI process to read the PRO and RUX files, etc. Or develop a solution using the TM1 REST API. tm1py has some support for this task at hand. Or commercial tools such as Pul...
by lotsaram
Thu Jun 29, 2023 2:01 pm
Forum: Jedox
Topic: Any Quality Open Source Olap ??
Replies: 19
Views: 661662

Re: Any Quality Open Source Olap ??

Well there's tinyolap https://tinyolap.com/
But this is single user in-process. Although the project bio talks about xP&A use cases I can't think of any real planning use case which is viable without multi-user and a security model.
by lotsaram
Thu Jun 29, 2023 1:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting Architect Users into PAW
Replies: 6
Views: 1788

Re: Getting Architect Users into PAW

Wow, can you please share more details? can't seem to find anything like it in release notes. I thought it's the other way around, there's now a way to sync PaW users to TM1 database now, like this https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=mugpadco-import-users-groups-from-planning...
by lotsaram
Fri Jun 02, 2023 3:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting Architect Users into PAW
Replies: 6
Views: 1788

Re: Getting Architect Users into PAW

Well until very recently you would have needed to set them all up again as users and security in Workspace are independent of the TM1 server. However, as of either PAW 86 or 87 users and groups from TM1 can now be used as a source for PAW. So as long as you go with the latest version you will be fin...
by lotsaram
Wed May 24, 2023 7:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove duplicate elements in MDX subset build
Replies: 6
Views: 1049

Re: Remove duplicate elements in MDX subset build

For a relatively small subset just use MDX with the + (union) operator between the elements. This will automatically do a distinct. I think this would be the most simple. SubsetMDXSet(dDimName, sSubName, Expand('{{[%dDimName%].[Planning]}+{[%dDimName%].[Budget]}+{[%dDimName%].[%PriorMonthForecast%]}...
by lotsaram
Tue May 09, 2023 7:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 2.0.9.16 Rule save time dramatically less - Feeder calcs?
Replies: 7
Views: 2193

Re: 2.0.9.16 Rule save time dramatically less - Feeder calcs?

We believe this is working differently to how it used to and we think this has appeared in either .15 or .16. We have many cubes with inter cube feeders, conditional feeders etc. On server startup the feeder process time for a particular cube is approximately 30 minutes. This has not changed with t...
by lotsaram
Tue May 09, 2023 7:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 2.0.9.16 Rule save time dramatically less - Feeder calcs?
Replies: 7
Views: 2193

Re: 2.0.9.16 Rule save time dramatically less - Feeder calcs?

Noticed this parameter in the TM1S.CFG - may be worthwhile checking/reviewing. Default is True though. SaveFeedersOnRuleAttach When set to False, postpones writing to feeder files until SaveDataAll and CubeDataSave are called, instead of updating the files right after rules are changed and feeders ...
by lotsaram
Wed Mar 29, 2023 7:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Displaying 'Value' column in an MDXView
Replies: 3
Views: 630

Re: Displaying 'Value' column in an MDXView

I would say it depends on the GUI. If it is architect or perspectives then no, it aint gonna happen since this uses the old API and has no concept of either hierarchies or MDX views. If it's a modern IDE like Arc or Workspace then this shouldn't be a problem.
by lotsaram
Tue Mar 28, 2023 7:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Displaying 'Value' column in an MDXView
Replies: 3
Views: 630

Re: Displaying 'Value' column in an MDXView

I guess you are talking about the preview window for TurboIntegrator?
by lotsaram
Thu Mar 23, 2023 11:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: what is difference between TM1 9.1 and TM1 11.6
Replies: 6
Views: 985

Re: what is difference between TM1 9.1 and TM1 11.6

Niko wrote: Wed Mar 22, 2023 12:44 pm Anyone Know what is difference between IBM Cognos tm1 9.1 and IBM Cognos tm1 11.6 <PA2.0.9> Version ?
I mainly want to know usability , such as Websheet function / RULE function / TI function , Any aspects what is frequently-used?
You do realize that TM1 9.1 came out in 2007?
by lotsaram
Thu Mar 16, 2023 11:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Lock.Exception Throwing IXConflict on object }DimensionProperties
Replies: 3
Views: 920

Re: TM1.Lock.Exception Throwing IXConflict on object }DimensionProperties

It might be related to MUN generation or the initial lock the first time a dimension is queried. After startup try looping through all dimensions and just doing a sEle = DIMIX(sDim, 1) within the loop (nothing else) then after the loop run RefreshMdxHierarchy. Doing that before the load process may ...