Search found 43 matches

by tsw
Mon Feb 03, 2020 6:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 14
Views: 1146

Re: TI MDX query of 2 different cubes

You can use calculated members in MDX. SO why not do a "with member as cubeA() * cubeB()" in your MDX query. Use that as the ODBO data source for your process on server2. well, I wished I knew this.. as this was the syntax I was looking for in my orig post. I couldn't find anything online. Can you ...
by tsw
Tue Jan 28, 2020 6:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 14
Views: 1146

Re: TI MDX query of 2 different cubes

Hi all, sorry for the late response. Clarification: I needed to mdx query and multiply server1.cubeA() * server1.cubeB() data to load into server2.cubeC I think some suggestions of exporting cubeA data and then reading it back to multiply by cubeB data before loading into server2 will work. But sinc...
by tsw
Thu Jan 23, 2020 9:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 14
Views: 1146

Re: TI MDX query of 2 different cubes

Since I can't do this in a single mdx query or process...
Maybe I can query cubeA() and get ResultA
then pass it into a sub-TI process and multiply ResultA with result of ResultB to load?
There's only a single row returned for each call of ResultA.. does this sound okay?
by tsw
Thu Jan 23, 2020 8:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 14
Views: 1146

Re: TI MDX query of 2 different cubes

A TI process can only have one cube as a data source so the standard way of handling this is to have one cube as the data source (the one with the main intersection of cells you are trying to process) then in the Data tab of that process you issue a CELLGETN against the secondary cube to get it's v...
by tsw
Thu Jan 23, 2020 7:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 14
Views: 1146

TI MDX query of 2 different cubes

Hopefully, this is an easy question for someone out here: I'm needing to ODBO mdx query a result from a TI process of data from 2 cubes (in same TM1 server) from a different TM1 server. cubeA(dim1,dim2,dim3) and cubeB(dim1,dim2) Is there syntax that allows me to either: do a calculated member like "...
by tsw
Thu Mar 21, 2019 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does anyone know how to run 2 PAW instances on same server?
Replies: 11
Views: 1923

Re: Does anyone know how to run 2 PAW instances on same server?

I suggest you log an RFE for PAW Local to support more than one environment (as it does on Cloud) -- i.e., dev / test/ prod tenants. Upcoming PAW releases will run on orchestration engines (Swarm/Kubernetes). Does submitting a RFE require support's help? it seems these new crop of first-level suppo...
by tsw
Tue Mar 19, 2019 6:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does anyone know how to run 2 PAW instances on same server?
Replies: 11
Views: 1923

Re: Does anyone know how to run 2 PAW instances on same server?

If IBM had made PAW ... Right, IMO, IBM made a mistake architecting this application in Docker without keeping this in mind. I was hoping someone on here who has more experience with Docker has done this already... I have a really powerful physical server which can run multiple containers without h...
by tsw
Tue Mar 19, 2019 5:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does anyone know how to run 2 PAW instances on same server?
Replies: 11
Views: 1923

Re: Does anyone know how to run 2 PAW instances on same server?

Out of curiosity. Why would you want to? IMHO, not being able to do this misses a major goal of application virtualization.. I believe one of the goal of Docker is to make virtualization more computing efficient by sharing the O/S host and financial efficiency by not having to pay for multiple oper...
by tsw
Mon Mar 18, 2019 6:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does anyone know how to run 2 PAW instances on same server?
Replies: 11
Views: 1923

Does anyone know how to run 2 PAW instances on same server?

Hi,

Does anyone have experience running multiple PAW instances on the same server? If so, can you please share what configurations need to be edited in order to do so?

Thanks!
by tsw
Wed Oct 18, 2017 7:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Anyone still on PVU only licensing server & client ?
Replies: 1
Views: 842

Anyone still on PVU only licensing server & client ?

Trying to find out if anyone out there is still on PVU-only licensing for both server side and client side?

Thanks!
by tsw
Thu May 14, 2015 4:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ranking Cube Methodology
Replies: 5
Views: 3363

Re: Ranking Cube Methodology

Just wanted to add another option since I recently had a need to do this. Similar to mce's suggestion, using relational DB's rank works.. but I wanted to find another possibility so I tried using R I'm new to R, but it looks like a wonderful framework and programming language to do some analytic wor...
by tsw
Fri May 01, 2015 7:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error opening Perfomance modeler-
Replies: 10
Views: 6156

Re: Error opening Perfomance modeler-

Steve Vincent wrote:your log contents are different to mine, are the versions of the PM client and the TM1 server identical?
Yes, they are same. And I verified the contents are same on 2 different machines.
by tsw
Thu Apr 30, 2015 5:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error opening Perfomance modeler-
Replies: 10
Views: 6156

Re: Error opening Perfomance modeler-

... Check AppData\Roaming\IBM\Cognos Performance Modeler\configuration for the user to see if any files exist in the versioned sub-folder that resides there. It is supposed to be created when PM is launched for the 1st time, in the case of the clients that won't run the sub-folder is empty. We were...
by tsw
Wed Apr 29, 2015 9:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do you deal with this BI reporting / TM1 feeder issue?
Replies: 11
Views: 4296

Re: How do you deal with this BI reporting / TM1 feeder issu

Given Brian's results, I am just wondering if you have AllowSeparateNandCRules in your TM1S.CFG? Good point. I did my test without AllowSeparateNandCRules set. If I set that config param I never see the column get zero suppressed. Hi Paul, Brian, I do have AllowSeparateNandCRules=T, and I tried put...
by tsw
Tue Apr 28, 2015 6:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do you deal with this BI reporting / TM1 feeder issue?
Replies: 11
Views: 4296

Re: How do you deal with this BI reporting / TM1 feeder issu

I just ran a quick test using the latest 10.2 rp2 fp3... Using these lines in the rule, the entire 'C' column is zero supressed ['C'] = N: ['A'] \ ['B']; ['C'] = C: ['A'] \ ['B']; However, if I replace that with the single rule line ['C'] = ['A'] \ ['B']; or even ['C'] = N: ['A'] \ ['B']; C: ['A'] ...
by tsw
Tue Apr 28, 2015 4:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error opening Perfomance modeler-
Replies: 10
Views: 6156

Re: Error opening Perfomance modeler-

I have this in one of my dev TM1 10.1.1 servers... I haven't had time to troubleshoot it... but as Sukumar suggested, I believe it has something to do with corrupted data as that server didn't start up correctly due to an unexpected hardware shutdown.
by tsw
Tue Apr 28, 2015 4:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do you deal with this BI reporting / TM1 feeder issue?
Replies: 11
Views: 4296

Re: How do you deal with this BI reporting / TM1 feeder issu

There is another aspect to this. If you are utilising the Dynamic Query Mode and are on TM1 10.1.1 or above and Cognos BI 10.2 or above then the default behaviour is for TM1 to do server-side zero suppression and it becomes impossible to see unfed values in BI regardless if you have zero suppressio...
by tsw
Tue Apr 28, 2015 4:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do you deal with this BI reporting / TM1 feeder issue?
Replies: 11
Views: 4296

Re: How do you deal with this BI reporting / TM1 feeder issu

Hi I would also suggest trying a single rule, rather than separate N: and C: rules ['C'] = ['A'] \ ['B'] ; Not sure if it will help but it might. If not, try feeding from B as well as A If not then David's idea is perhaps the only way. I think that you are possibly getting the issue because all the...
by tsw
Mon Apr 27, 2015 10:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do you deal with this BI reporting / TM1 feeder issue?
Replies: 11
Views: 4296

Re: How do you deal with this BI reporting / TM1 feeder issu

Your use case is pretty strange I'd say. I would suggest making C the parent of A and B. Think that would fix it. Hi David, brilliant! I haven't tried it in BI yet, but at least the TM1 engine won't zero-suppress it. So, is the idea to use C as a consolidation level to make it unnecessary to use fe...
by tsw
Mon Apr 27, 2015 10:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is Cognos TM1 getting better?
Replies: 24
Views: 10989

Re: Cognos TM1 and Bugs

In recent discussion with an IBM Support rep, at least one of the issue is how IBM is redefining what a defect is to make their internal KPIs look better than it really is... therefore less actual defects get fixed. I've had a couple of real defects according to traditional software development, yet...