TM1 Forum

Yeah I was trying to avoid doing a loop. Why do you want to avoid doing a loop? I would say that for this sort of thing a loop be it on a dimension, subset, or "lookup dimension" (as per Burnstripe's comment) is *almost* essential - and very likely the most efficient way of doing it. Ther...

In PAW when you select a sandbox, you are selecting it for a widget rather than the whole session. You can have it also apply to other widgets by using the Synchronization settings. But I don't think Process Buttons in PAW have synchronization options that are capable of syncing sandboxes. If the ab...

You need to do some form of loop on the data tab where you loop through the weeks dimension. The most basic form of this would be to simply loop the entire dimension e.g. iCount = 1; iMax = DimSiz ( cDimWeek ); While ( iCount <= iMax ); sWeek = DimNm ( cDimWeek, iCount ); If ( DType ( cDimWeek, sWee...

You can have both element and component sort as “byinput”. You then have to use something like a shadow dimension to do all of your manual sorting in and then have a TI process do complete rebuilds on your main dimension with the shadow dimension as a source, the code then very carefully inserts new...

Sorry, I think I have different opinion on this. That was my first impression as well originally but after auditing, IBM says if you have ReadWrite user license, you need to let that user be able to write something back to TM1. You can't simply group your ReadOnly users under ReadWrite license umbr...

A standard performance management user is your bog standard read/write contributor/planner. As far as IBM are concerned if you pay for someone to have write privileges but only grant them read access - that is fine as it’s lower access. You could buy an explore/read only licence that’s cheaper so IB...

My recommendation is usually CAM authentication for full SSO compatibility with all interfaces and it gets hooked up to AD. But just 1 or 2 CAM groups per TM1 instance that give basic access. Then once the users are authenticated in TM1 we have internal mode 1 groups that assign the actual user acce...

DataSourceNameForServer = <CubeName>;
DataSourceCubeView = <ViewName>;

On the prolog tab.
You need to make sure the view that you originally set it up with has at least the same number of columns etc in order to be able to use the variables.

The only thing I can think of would be to turn on stargate view logging (tm1s-log.properties). You would then theoretically be able to see from this point on whether the cube is queried, but you wouldn't be able to retroactively check to see in the past before the point you enabled logging. It would...

is there any other way (besides quick-report with committing values to a cube)? Your easiest option available is probably just to have hidden columns which contain DBS formulas to send the data from the cells into the cube. For the DBS formulas you can add an IF statement that looks at a single con...

It's pretty quick and dirty but if you hook up the below code to the attached CSV it should give you an idea of what you could do. #Section Prolog #****Begin: Generated Statements*** #****End: Generated Statements**** #----------------------------------------------------- # Set Constants and Variabl...

If your users work with an interface that allows the use of alternate hierarchies I would scrap the current set up and replace it with a dimension that just contains the core roll ups - which sounds to be location based info. And then an additional hierarchy linking the n-level element to an Agency ...

I don't use websheets much nowadays but in a previous build (before PAW even existed) I remember adding a cheat method on particular websheets. If users were entering data to "Revenue" as a measure element I would add a consolidation called "Revenue_Input" that only contained &qu...

Hi, A "Custom Report" is static in terms of the rows that are displayed (there are some tricks to make it not static but we won't get into that.) A "Dynamic Report" has the POTENTIAL to have a dynamic list of elements in the rows. It is driven by a TM1RptRow formula (link below) ...

That hidden section in the exploration views is great for dragging in the virtual sandbox dimension as well (assuming you have it enabled) without having to go through the full navigation pane.

This may look like a boat load of ugly, but it will do what you are asking in your op. This query assumes you have only one level above the periods, say "Total Year". PERIODSTODATE( [Manad].[Level000], TM1MEMBER( TAIL( FILTER( [Manad].[Total Year].children, [cubename].([z.TestRowEntryList...

I don't recall specifically seeing this either but just a thought came to mind. Are you using the web url api to open additional windows? Its a complete guess but I wonder if that opens as a separate thread and they don't get disconnected. However, I used to use the url api a lot and don't recall se...

This sounds like a bug that caused me to question my sanity last week: https://ibm.com/support/pages/apar/PH31597 IBM have stated its planned to be resolved in PA 2.0.9.6 LC and PA 2.0.9.1 IF 7 The incident and support team suggest that there are many potential causes of this which have not yet been...

Personally, if this is a one off job I would be inclined to just do it manually in PAX/perspectives with simple lookups to decide where you want to paste the values into.