TM1 Forum

Have a rather perplexing problem. Need an action button to navigate to one of two other possible target sheets but need the target sheet to be conditionally determined based on the row element of the selected DBRW. I know this isn't natively supported so I have a VLOOKUP that will extract the target...

I know it's obvious but sometimes it's the little things that get us; have you confirmed that the calculation mode in Excel hasn't changed from manual to automatic?

Yes.

I have a VBA routine that uses the QUSUBSET macro function to retrieve into an Excel worksheet a set of non-zero elements. I have been using this for some years now and it usually takes less than 5 seconds to execute. After upgrading to 10.1, it has now started taking between 30 and 60 seconds which...

Duncan - thanks for the suggestion of reversing the order of comparison. I set it as follows and it works fine:

...
!Period @= ATTRS('Version_Core', 'Forecast', 'ActualsMonth') &
!Entity_Core @= ATTRS('Job', !Job, 'Entity'),
12,0);

Not sure why it would make a difference but it does.

I am getting syntax error messages when attemping to use more than one ATTRS comparion in an IF statemenet in a rule, which is as follows: ['4310.10', 'TSE - Actual - Rule', 'Current Activity']=N: IF( DB('Control', 'Post_WOH_JE', 'Input')@='1' & ATTRN('Job', !Job, 'UseConstructionCalcs')=1 &...

I have a pretty simple G/L cube with the dimensions Entity, Account, Job, Period, Version, Measure. Each element of the Job dimension "belongs" to an element of the Entity dimension and that relationship is specififed via an "Entity" attribute of the Job. I want to write a rule a...

Thank you. One thing I'm not clear on is how this works with the reality that the current user's permissions is defined by there membership in the collection of groups they are members of so I am not sure how to determine the permission of a particular user to elements?

Try as I may, I have not been able to figure out how to create a dynamic subset based on element security. I need to define a subset limited to elements for which the current user has Write permissions. Is this possible? FWIW - This all has to be done through Excel VBA such as the elements contained...

You would think this is simple but I'm trying to write (thru Excel) a string value to to the }ClientGroups control cube with no success (keep getting *KEY_ERR). I have checked the syntax, spelling, etc. a hundred times. What obvious thing am I missing?? Is there a prohibition on writing directly to...

You would think this is simple but I'm trying to write (thru Excel) a string value to to the }ClientGroups control cube with no success (keep getting *KEY_ERR). I have checked the syntax, spelling, etc. a hundred times. What obvious thing am I missing?? Is there a prohibition on writing directly to ...

I have an unexpected issue with a budgeting application I just rolled out. It appears that the data users are entering through Excel (DBSWs) is being stored by default in their "Personal Workspace" and hence not in the "base" data available for all to see. I understand that I can...

Does anyone know if Cognos has any plans for exposing more of the API functionality through VBA (I guess essentially a VBA wrapper around the API)? The API is obviously very difficult to use.

Wow! you put a lot of effort into that! Thanks for the info. I suspect your are right about the permissions issue as this was inadvertanlty chnaged during the upgrade to 9.4 and I thought it had all been corrected but apparently not. Thanks again and I will look into that. Point about including rele...

Has anyone else noticed that in 9.4.1 the subset editor does does not retain the previous view settings (screen placement, size, etc) when closed? For example, in 9.1, each time I opened a subset editor for any dimension, it would open in the same place on the screen and at the same size it was when...

Does anyone know if there is a way to open up a cube browser with VBA (and ideally with a specified layout and subsets present)?

Is there a way to determine through VBA whether a user is logged in to TM1? I have a reporting spreadsheet with a lot of VBA code, some of which I only want to execute if the user is logged in.

I think I just figured this out. It is not a VBA issue. If any of the elements are invalid, the function will fail silently and act like it just didn't execute. You can trap this by capturing the bollean return value into a variable. Returns true is successfully created the view and false if not.

It seems that I may have stumbled accross the answer. It appears that the declaration syntax in the help file is incorrect. The help file is:

Declare Function TM1APIFinalize Lib "tm1api.dll" ()

but it should be:

Declare Sub TM1APIFinalize Lib "tm1api.dll" ()

I am trying to learn the TM1 API and will probably post a few questions here as I do. The firt problem I'm having is properly disconnecting and cleaning up the session. I have followed the example in the help file verbatim and use the function TM1APIFinalize as the final line. The problem is that I ...

6.5