TM1 Forum

Thanks for your reply William. I am familiar with the REST API and executing MDX queries using Python and TM1py. However, I'm not sure how the API can be leveraged from within a Cognos Analytics prompt or report? We have existing CA reports that make use of TM1 subsets. CA allows for report elements...

In CA, a prompt can be utilized to pick a dimensional element and then use that selection in a crosstab with a data item expression like: [tm1_cube].[Products].[Products]->?p_tree_selection? We are in dire need of equivalent functionality but with specifying a subset to use rather than a dimension s...

For those who haven't yet run into this major limitation, clipboard content originating outside the browser (like from Excel) cannot be pasted into PAW websheets . IBM discloses this right in their documentation. Copy/paste into native PAW cube views is supported but not into websheets which is a fu...

As I've yet to find an official method to automate Cafe login and refresh with TM1 objects, I had to go down the emulation path. Below are two AutoIT scripts that get the job done. The first is the actual Cafe refresh script while the second is for maintaining a username/hashed-password .ini file (n...

Is Cafe's VBA automation only for BI objects and not for TM1 worksheet objects/references like dbrw's and flexviews?

The documentation does not make this distinction but the login function appears to want a BI server reference and not a TM1 app server URL.

Please tell me this is not true!

Thanks.

kangkc wrote:Interim fix IF4 is available which will solve this problem. Not sure this is available on fix central for download.

Can you please confirm that it's IF4? Our support rep is saying IF2 is the latest. Thx.

I don't have high hopes for a resolution to this but thought I'd throw it out there. We're getting ready to move a large population (700+) TM1Web users from 10.1 to 10.2.2. These users make heavy use of customized subsets which they change between frequently. In 10.1 and prior, users were able to qu...

Yes, thank you lotsa... that was it. I'm used to Unix commands where optional parameters mean optional!

I'm testing TM1's 10.2.2 FP1 undocumented SubsetMDXSet function ( see http://www-01.ibm.com/support/docview.wss?uid=swg27042401 ) and thus far cannot get it to function as documented: ### total_lvl_0_w_alias vDim = 'Legal_Entity'; vMdx = '{[legal_entity].[Total Company],TM1SORT( {TM1FILTERBYLEVEL( {...

Can anyone shed light on this Cognos CAFE message: "Formula mode required registration and will not work until Excel is restarted" I've only been working with CAFE for a couple of days and get this message roughly half the time when clicking the IBM Cognos button. I have, BTW, added in the...

BTW, I found this in tm1web_config.xml which seems tantalizingly close to what I wanted, but alas, it doesn't appear to apply to CAM security:

Thanks for the confirmation... I'll open a ticket with IBM.

-- John

I was hoping someone might have a solution to or can confirm the following behavior in their environment. Environment: TM1 10.2.2 with Cognos CAM security (mode 5) Behavior: 1) User is logged into TM1 Web 2) User session time's out or user clicks "Log Out" 3) User is redirected to what I b...

Trying to do the same thing... did you or anyone else ever get this figured out?

Thanks,

-- John

Hey Wim, Nice to chat with one of the TM1 legends. :) As for the pFirst check, I've actually found it useful to be able to disable the file delete. For example, if you want to export two different consolidated members of the same hierarchy, you run the export on the first member and then pass in pFi...

Instead, you need a starting script which does the AsciiDelete and then kicks off the process. Or one additional parameter, like pMode, set to 1 initially. When doing a next call to the process, set the pMode = 0. In the code, test if pMode = 1. If yes, AsciiDelete. If not, no AsciiDelete. Yes, goo...

One important callout is that you do need to delete the output file before calling the process: Can you use the AsciiDelete function? Not in this case as the process calls itself repeatedly and the text file needs to persist. Instead, you need a starting script which does the AsciiDelete and then k...

I thought I'd share the following process as I wasn't able to find anything in the archive that quite fit the bill. Objectives: 1) For a given consolidated member and its descendants, output: Child, Parent, Child_Alias, Weight 2) Output in a tops-down manner where parents are always defined before c...

Probably a dumb question, but have you confirmed that the processes (both tm1s.exe and the shared memory reader) are actually dead?

An 'lsof -i:11446' may also yield useful information.

What Unix are you running?

-- John

*bump*

Same question. Anyone found a way?

Thanks.
-- John