TM1 Forum

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

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

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%]}...

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

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

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.

I guess you are talking about the preview window for TurboIntegrator?

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?

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

There is also the TI function PublishView. You could just let the user run the bedrock view publish process

Excellent. Thanks for the update! Glad that you got it to work.

The real code rather than the pseudo code makes it much easier to see.

Good points, @Maren - but I was following the conventions set out by our software developer consultant (who we are no longer getting help from) and they haven't thrown up issues before. With all due respect to your former developer. If their advice and "best practice" was to create perman...

As David Usherwood is now enjoying retirement I can only repeat the point he has made countless times on this forum; the purpose of feeding is for consolidation ergo if a rule calculated measure doesn't need to consolidate then don't feed it. Rates are such a measure, you shouldn't feed rates.

RFAG #5 Post the actual code! https://www.tm1forum.com/viewtopic.php?t=1037 Show the actual rule that isn't working, not just a snippet. Show the WHOLE rule, including the left hand side. Show the structure of BOTH cubes. If you want help, put in the required minimum effort that people can actually ...

Did you create a hierarchy? Becasue from the picture you included it doesn't really look like it. It isn't enough to have an attribute in Product dimension matching an element name in Product_Dashboard dimension - you must have a consolidation which exactly matches the name.

I don't really have anything to add to Wim's already excellent post except to emphasize that creating a new process each time you want to load data from one cube to another seems like a very odd thing to do. Much better to simply have a generic process to do this job.

When I connect to TM1 via excel, I am getting a RECALC error when I try to refresh my DBRW formulas. I have the add-ins, have tried DBR and DBSW formulas but it still is not working. Any ideas? Thank you If you are using Perspectives this is normally caused by linking a DBRW formula to another DBRW...

I tried the CellPutS but the trick didnt work. :-( Maybe also try CellPutS to the element security cube. What George said rang a bell and I think I can recall needing to do this. (Why I don't know becasue AFAIK ElementSecurityPut should alone be adequate). HierarchyElementSecurityPut(sElSecurity, p...

I agree this sounds strange. If element security cubes don't contain rules then the ElementSecurityPut function should be sufficient to update security without needing a SecurityRefresh.

At least as far as Arc goes you can raise a feature request