TM1 Forum

"Could not connect to server "tm1instance" on admin host "servername" Looks like our problems are all over the place. Got VMs connecting with no problem, Perspectives connects with no problem on a client laptop, but on the same client, Architect will display the instances an...

Has anyone had trouble getting TM1Top to work with the new IBM SSL certificates? I have been unable to get it to work. No problem with Ops Console.

Yes, the functions are available in 10.2.2 FP1 and have started using it. Thank You for the response. I used to convert the dynamic subset in to static subset same way you explained. Looping elements and create static subset in a TI makes TI faster in processing time than making dynamic subset to st...

Tom beat me to the click, but what he recommends is much cleaner.

Tom, I've not used that function. I assume it handles MDX that does not return a set without bombing?

What exactly is your process doing? If you are reading and writing within the same cube (and in some instances inter-cube) the CELLPUT may destroy the read cache and causes the MDX to recalculate which greatly slows down the process. The second method you are using is building a static subset, so it...

Lotsaram I have in the past as well, and I tested using a copy of the }Cubes dimension, which still acted ugly. It turned out we were able to replicate the bad behavior as long as: 1) we were using a client, not a VM or logged into the actual server 2) the picklist was a dimension, not a subset on t...

Okay, just in case anyone wonders, switching to a subset vs a dimension picklist, seems to have resolved the problem.

Additional testing had demonstrated that our DEV environment is a problem as well WHEN connecting through Architect from a client laptop.

We have a cube we use to designate cube dependencies at server restart: }System - Cube Dependencies. It has two dimensions: Counter: 135 elements 0-134 plus a consolidation element TOTAL. }System - Dependency Measure with two elements, Base Cube and Dependent Cube. There is a cube: "}Picklist_}...

Ah. My apologies.

{FILTER(TM1FILTERBYLEVEL(TM1SUBSETALL([Accounts_OPEX_PLAN]) , 0) , [PLAN_Param_CCToGL].([CostCenters_OPEX].CURRENTMEMBER,[StrNum].[nValue]) = 1)} Since the CostCenters_OPEX is a title dimension, the [CostCenters_OPEX].CURRENTMEMBER is not needed for a cube view. It will automatically filter it for ...

Wim,

I think I've got it. Here is the MDX code that returns a subset wherever the members appear. MDX:

Sorry, Wim, I see now what you're wanting. Say, given "Coy", you want to see the hierarchies Coy is a member of represented fully from the top to Coy. Hmmmm, tricky...

So in my example, you would want to see the hierarchies for say, just Georgia and Alabama?

Wim,
seems to return the subset you were looking for originally by the way.

Result: I did not see the rule over-ridden Account in the output file.

That is inconsistent with all of our testing and experience.

So weights can vary for each element depending on where it is in the hierarchy/hierarchies?

I could think of a boatload of attributes to capture all parent names in all 4 hierarchies using attributes on the customer dimension, but that does not seem like the best solution to me and would still need a way to capture the ancestor information at a certain time. What if you had an attribute &...

One trick to remember is to always dirty the cube(s) you impact i.e. if you swap a measure, make sure you change a value in each cube that dimension is used in, then save data. Performed the following steps: 1) Swapped the ElemX and ElemY with ElemXa and ElemYa aliases. 2) Dirtied the cube, changin...

SwapAliasWithPrincipalName is known to have some issues and wouldn't be trusted fully. Couldn't you export the data and do the necessary changes and import it back.Of course data backup is mandatory.It far more reliable and easier.Thanks. Yes, but this dimension affects a lot of cubes, so that is t...