Search found 44 matches

by MarioRubbo
Wed Sep 21, 2011 5:23 pm
Forum: Cognos Planning and BI
Topic: TM1 Subsets in Report Studio
Replies: 5
Views: 7905

Re: TM1 Subsets in Report Studio

You have to use one of the Studio tools in BI to create the sets. There is no simple set of steps to list out because there are many different kinds of sets that can be created using various methods in TM1 and BI. As far as Views go, you would create reports in BI that mimic the rows/columns/and fil...
by MarioRubbo
Thu Jan 20, 2011 4:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: File size limitation on .CUB files?
Replies: 9
Views: 6496

Re: File size limitation on .CUB files?

Hi Jim: I would normally implement a solution with the same components described but this project presents problems because of the shear volume. As far as the problem you experienced, my guess is that you had an ever exploding number of summary tables/materialized views and the process of keeping th...
by MarioRubbo
Thu Jan 20, 2011 2:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: File size limitation on .CUB files?
Replies: 9
Views: 6496

Re: File size limitation on .CUB files?

Thanks, guys. Ideally, I would be using an OLAP solution for this reporting project and I am trying to determine if I should even attempt TM1 as a possibility. Ultimately, I think I will need to stick with more of a ROLAP solution - rather than a MOLAP approach. My fact table is absolutely huge and ...
by MarioRubbo
Wed Jan 19, 2011 8:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: File size limitation on .CUB files?
Replies: 9
Views: 6496

File size limitation on .CUB files?

Is there a 2GB limit on the size of a .CUB file? I have an extremely large database in Oracle that I would like to make OLAP-capable. I am limited by budget to Cognos OLAP tools (PowerPlay and TM1) and I have have already reached size limitations in Cognos PowerPlay. I don't think TM1 can handle the...
by MarioRubbo
Mon Oct 18, 2010 5:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DISTINCT Counts in TM1
Replies: 13
Views: 13163

Re: DISTINCT Counts in TM1

@tomok: all OLAP solutions that I know of have multiple rollup calculations available for measures. There are many types of analytical questions that revolve around counting things: # of customers that bought last month, etc.
by MarioRubbo
Mon Oct 18, 2010 1:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DISTINCT Counts in TM1
Replies: 13
Views: 13163

Re: DISTINCT Counts in TM1

Is it really not possible to do a Distinct Count measure in TM1 ?
by MarioRubbo
Fri Jul 16, 2010 5:36 pm
Forum: Useful code, tips and tricks
Topic: TI Chore and Process EXEs
Replies: 13
Views: 19148

Re: TI Chore and Process EXEs

Here is a UNIX utility that I've developed using the Java API. For UNIX environments, you can use this to kick off TM1 Chores from an external OS utility and/or scheduling program AutoSys, etc.
utilities.zip
UNIX shell scripts to build and run, Java source and binary to run
(83.5 KiB) Downloaded 747 times
by MarioRubbo
Wed Jul 14, 2010 2:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Maps in IBM Cognos Express
Replies: 1
Views: 1955

Re: Maps in IBM Cognos Express

As long as the codes in your data match with the expected codes from the map, C8 will correctly match them and display the colors. You don't need MapInfo unless you need a custom map with corporate regions, etc. that can't be found in the (limited) standard maps that are included.
by MarioRubbo
Mon Jul 05, 2010 9:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exploding memory requirement with C8
Replies: 4
Views: 3390

Re: Exploding memory requirement with C8

I've had the same issue with a really big dimension in TM1 exposed through C8. I was never able to find a fix. I tried adding artificial hierarchy levels to make it easier to digest by C8 but it continued to choke.
by MarioRubbo
Mon Jul 05, 2010 1:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Any useful utilities to clean up old log files?
Replies: 5
Views: 4724

Any useful utilities to clean up old log files?

Hello everyone: Working on my first real, long-term TM1 engagement and I'm noticing some maintenance issues. E.g. The log directory continues to grow and eat up space. Does anyone have any best-practice utilities/suggestions for maintaining the log directory: e.g. batch file to bring down server eve...
by MarioRubbo
Mon Jul 05, 2010 12:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: regarding paramterised query in tm1
Replies: 10
Views: 6066

Re: regarding paramterised query in tm1

angel1234:
The str() function is the example I sent you is specific to the Sybase database that I am using. You need to substitute it with the appropriate datatype conversation function for Access.
by MarioRubbo
Sun Jul 04, 2010 4:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: regarding paramterised query in tm1
Replies: 10
Views: 6066

Re: regarding paramterised query in tm1

angel1234:
I have only been able to get this to work for me by treating everything as string. I had a similar circumstance and I had to cast my Year column as a string and then compare that to my parameter in TM1 which I defined as a string.

e.g.
where str(year_num,4) = '?year_num?'
by MarioRubbo
Fri Jul 02, 2010 5:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Corrupted dimension?
Replies: 3
Views: 3195

Re: Corrupted dimension?

I still occasionally have this problem with my installation of TM1 on AIX. I had the problem today on a dimension called "goc_function". I ran a TI process against it to update it from the database (set to Recreate) and populate attributes. The TI process froze during the Data Procedure. I...
by MarioRubbo
Thu Jul 01, 2010 1:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1-MDX-funtions in Cognos Reports
Replies: 1
Views: 2273

Re: TM1-MDX-funtions in Cognos Reports

You can't use any TM1 Subsets, Views, etc. in BI. You have to find equivalent functions in one of the Studios (Report Studio for example). C8 Report Studio has a very rich set of MDX functions exposed that you should be able to use. All the functions exposed in the Expression Editor are available to...
by MarioRubbo
Wed Jun 30, 2010 1:21 pm
Forum: Useful code, tips and tricks
Topic: TI Chore and Process EXEs
Replies: 13
Views: 19148

Re: TI Chore and Process EXEs

Does anyone know if a UNIX version of these utilities exists somewhere? I need to kick off a cube build from an external scheduling utility called AutoSys. TM1 is running on an AIX server. Alternately, if anyone can suggest an approach for developing this utility, I would appreciate it. For example,...
by MarioRubbo
Tue Jun 29, 2010 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1s-log.properties
Replies: 5
Views: 6897

Re: tm1s-log.properties

Steve: At a high level, the reference to Apache is meaningless. This component "log4j" is open source code sponsored by the Apache Foundation to provide a standardized way for Java programs to do logging. Apache also sponsors a web server but that is not in play here. IBM is a big Java pro...
by MarioRubbo
Mon Jun 28, 2010 4:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1s-log.properties
Replies: 5
Views: 6897

Re: tm1s-log.properties

This is what I have. I believe everything is set up correctly. My problem is that TI logs are written to the UNIX server but I am not able to see them from the TI Editor... # # Enable INFO level logging through the rolling file appender, by default. The server # will write informational messages, as...
by MarioRubbo
Tue Jun 22, 2010 5:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Corrupted dimension?
Replies: 3
Views: 3195

Corrupted dimension?

Hello: I have a dimension called "Products" that I am trying to manipulate. I created and recreated successfully. Suddenly, when I try to access it via TI or even the Subset Editor, my Perspectives client freezes and I have to kill the client and start over again. I plan to bring down the ...
by MarioRubbo
Wed Jun 16, 2010 1:37 pm
Forum: Cognos Planning and BI
Topic: Performance Tips
Replies: 2
Views: 4545

Re: Performance Tips

Are your dimension in TM1 large - i.e. are there a lot of elements? I have found that BI comes to a screaming halt when I am trying to explore a TM1 cube that has big dimensions.
by MarioRubbo
Tue Jun 15, 2010 6:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AIX TM1 9.5 connecting via ODBC
Replies: 4
Views: 4578

Re: AIX TM1 9.5 connecting via ODBC

The choice of 32-bit vs 64-bit is driven by your TM1 installation. If TM1 is 32-bit, then you need 32-bit unixODBC Driver Manager and a 32-bit ODBC database driver. This is regardless of the actual database architecture (32-bit vs 64-bit). In my case, TM1 was 64-bit so I had to get 64-bit drivers AN...