Recent content by monsky

Hi DoubleD, Here's an example of the Folder Organization: -Period - Date - Year - Month - Fiscal Year - Fiscal Month -Agent -Agency -Agent Balances -Agent Income -Agent Balances -Policies - Issue Date - Submit Date - Paid Up Date - Policy Number Now, the Policies folder have several...

Hi guys, I'd like to know if Data Stage has the ability to handle Slowly Changing Dimensions? I'm not sure of this but when I went to their site they seem to use Cognos Decision Stream as an add-on to handle this. Can you guys confirm this?

Hi guys, We're trying to figure out if it's possible to calculate the age of a policy by getting the difference between the current date and date issued. We want the difference to be in terms of months. Currently we're doing this calculation via stored procedure in Sybase after loading. We...

Yup, it really depends on the software. A faster processor may speed things up but will not really utilize 100% of the processor. I don't know if it will help but you can try adjusting the priority of excel by right clicking on it in the processes tab in Task Manager.

I have a period table where I filter on a fiscal month and fiscal year. My picklist is a text file that contains two columns: fiscal month as numeric, and the corresponding month name. 1 December 2 January 3 February 4 March 5 April 6 May 7 June 8 July 9 August 10 September 11 October 12...

Hi Guys, Given a fact table that has several date keys and one period table to which I will relate these keys. The approach to be taken is to create views for the period table for each role creating virtual period tables. First question, is it a good idea to represent this as alias tables in...

Can you elaborate on this?

Hi guys, I'm experiencing pc hangups whenever I install Windows XP installation particularly during the part after I entered my serial number. I suspected that it may be memory so I tried changing the memory with another that I know is working well. However, same situation happens. I've...

Already tried this. The catalog opens ok and so does the catalog. This error happens when drilling through from my cube.

Hi guys, I created a PowerCube that has a drill-through to an Impromptu Report. Once I click on drill-through Impromptu is launched and I get prompted with the Catalog user ID and password. Upon entering them I get the error: DMS-E-YV_SGINOLIB, Unable to locate the gateway 'sydba.DLL'. I am...

Hi yksvaan, I haven't gone back to you about this solution. Apparently haven't really tried this successfully. Please bear with me as I'm not a real expert in PowerPlay yet. Am I right to assume that each of those queries are to be saved as individual .iqds? If so, when I add them as data...

Hi guys, Just like to know if Cognos Impromptu sessions with a Sybase RDBMS are terminated in the event it hangs and that you need to terminate Impromptu via task manager? Does Cognos have a utility to terminate an aborted session that may still be existing in the RDBMS in this case?

Hi guys, I'm trying to figure out how to make a better design for a set of fact tables for a data mart. The report needs to show a previous month's statement balance amount then the net transactions for a month. To be able to do this I have to use two tables. The first table contains a...

Hey guys, I have a report that shows shows a monthly transaction for a given period. The report contains a prompt that would ask for the beginning date (e.g. 2004-01-01) and ending date (2004-11-31). Now, what I'd like to do is to display the beginning periods at the report header but instead...

I'm encountering the same problem. There is no red X but when I run the report nothing comes out. I removed any filters and checked the joins. I don't get any errors. I don't think I have any problems with the Sybase drivers since when I use on other catalogs and reports they work fine...