Search found 44 matches
- Wed Sep 21, 2011 5:23 pm
- Forum: Cognos Planning and BI
- Topic: TM1 Subsets in Report Studio
- Replies: 5
- Views: 8028
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...
- 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: 6646
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...
- 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: 6646
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 ...
- 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: 6646
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...
- Mon Oct 18, 2010 5:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DISTINCT Counts in TM1
- Replies: 13
- Views: 13331
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.
- Mon Oct 18, 2010 1:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DISTINCT Counts in TM1
- Replies: 13
- Views: 13331
Re: DISTINCT Counts in TM1
Is it really not possible to do a Distinct Count measure in TM1 ?
- Fri Jul 16, 2010 5:36 pm
- Forum: Useful code, tips and tricks
- Topic: TI Chore and Process EXEs
- Replies: 13
- Views: 20486
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.
- Wed Jul 14, 2010 2:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Maps in IBM Cognos Express
- Replies: 1
- Views: 1978
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.
- Mon Jul 05, 2010 9:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exploding memory requirement with C8
- Replies: 4
- Views: 3441
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.
- 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: 4801
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...
- Mon Jul 05, 2010 12:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: regarding paramterised query in tm1
- Replies: 10
- Views: 6162
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.
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.
- Sun Jul 04, 2010 4:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: regarding paramterised query in tm1
- Replies: 10
- Views: 6162
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?'
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?'
- Fri Jul 02, 2010 5:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Corrupted dimension?
- Replies: 3
- Views: 3272
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...
- 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: 2294
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...
- Wed Jun 30, 2010 1:21 pm
- Forum: Useful code, tips and tricks
- Topic: TI Chore and Process EXEs
- Replies: 13
- Views: 20486
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,...
- Tue Jun 29, 2010 2:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: tm1s-log.properties
- Replies: 5
- Views: 6966
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...
- Mon Jun 28, 2010 4:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: tm1s-log.properties
- Replies: 5
- Views: 6966
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...
- Tue Jun 22, 2010 5:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Corrupted dimension?
- Replies: 3
- Views: 3272
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 ...
- Wed Jun 16, 2010 1:37 pm
- Forum: Cognos Planning and BI
- Topic: Performance Tips
- Replies: 2
- Views: 4650
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.
- 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: 4616
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...