Search found 125 matches
- Thu May 04, 2023 6:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Reference PA Subset Dynamically in Cognos Analytics
- Replies: 2
- Views: 1955
Re: Reference PA Subset Dynamically in Cognos Analytics
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...
- Thu Apr 27, 2023 2:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Reference PA Subset Dynamically in Cognos Analytics
- Replies: 2
- Views: 1955
Reference PA Subset Dynamically in Cognos Analytics
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...
- Thu May 21, 2020 2:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Websheet Copy/Paste from Excel
- Replies: 0
- Views: 3090
PAW Websheet Copy/Paste from Excel
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...
- Mon Nov 16, 2015 5:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cafe VBA TM1 Automation
- Replies: 1
- Views: 3445
Re: Cafe VBA TM1 Automation
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...
- Wed Nov 11, 2015 11:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cafe VBA TM1 Automation
- Replies: 1
- Views: 3445
Cafe VBA TM1 Automation
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.
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.
- Mon Mar 16, 2015 9:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Fix Pack Releases: 10.2 Series
- Replies: 49
- Views: 300178
Re: Fix Pack Releases: 10.2
Can you please confirm that it's IF4? Our support rep is saying IF2 is the latest. Thx.kangkc wrote:Interim fix IF4 is available which will solve this problem. Not sure this is available on fix central for download.
- Mon Jan 26, 2015 3:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web 10.2 Subset Editor "Basic" View
- Replies: 0
- Views: 2317
TM1Web 10.2 Subset Editor "Basic" View
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...
- Mon Jan 19, 2015 5:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Does SubsetMDXSet Work?
- Replies: 3
- Views: 5791
Re: Does SubsetMDXSet Work?
Yes, thank you lotsa... that was it. I'm used to Unix commands where optional parameters mean optional!
- Fri Nov 28, 2014 6:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Does SubsetMDXSet Work?
- Replies: 3
- Views: 5791
Does SubsetMDXSet Work?
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( {...
- Thu Jul 17, 2014 9:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CAFE: "Formula mode required registration ..."
- Replies: 3
- Views: 5120
CAFE: "Formula mode required registration ..."
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...
- Mon Jul 14, 2014 10:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web: User "Log Out" does not return to Login Screen
- Replies: 12
- Views: 14326
Re: TM1 Web: User "Log Out" does not return to Login Screen
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:
Code: Select all
<!-- LogoutUrl to be executed after logout normally completes-->
<add key="CustomCAMLogoutUrl" value="" />
- Fri Jul 11, 2014 2:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web: User "Log Out" does not return to Login Screen
- Replies: 12
- Views: 14326
Re: TM1 Web: User "Log Out" does not return to Login Screen
Thanks for the confirmation... I'll open a ticket with IBM.
-- John
-- John
- Thu Jul 10, 2014 2:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web: User "Log Out" does not return to Login Screen
- Replies: 12
- Views: 14326
TM1 Web: User "Log Out" does not return to Login Screen
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...
- Fri Jun 06, 2014 7:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Multiple Portals in variables_tm1.xml
- Replies: 2
- Views: 3004
Re: Multiple Portals in variables_tm1.xml
Trying to do the same thing... did you or anyone else ever get this figured out?
Thanks,
-- John
Thanks,
-- John
- Fri Apr 18, 2014 10:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tops-down child/parent dimension export
- Replies: 8
- Views: 6697
Re: Tops-down child/parent dimension export
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...
- Fri Apr 18, 2014 6:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tops-down child/parent dimension export
- Replies: 8
- Views: 6697
Re: Tops-down child/parent dimension export
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...
- Fri Apr 18, 2014 6:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tops-down child/parent dimension export
- Replies: 8
- Views: 6697
Re: Tops-down child/parent dimension export
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...
- Fri Apr 18, 2014 3:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tops-down child/parent dimension export
- Replies: 8
- Views: 6697
Tops-down child/parent dimension export
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...
- Tue Sep 25, 2012 9:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: "15","E15) Server unable to listen on port
- Replies: 3
- Views: 5666
Re: "15","E15) Server unable to listen on port
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
An 'lsof -i:11446' may also yield useful information.
What Unix are you running?
-- John
- Thu Jul 19, 2012 5:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Disable Taking Ownership in a Central Application
- Replies: 4
- Views: 4644
Re: How to Disable Taking Ownership in a Central Application
*bump*
Same question. Anyone found a way?
Thanks.
-- John
Same question. Anyone found a way?
Thanks.
-- John