Search results for query: *

I recall that DB2 uses a setting that allows the db to take less or more time to spend on creating the most optimized explain. I forgot the name of this parameter, but setting it to a higher value would only be beneficial for complex queries. The range I recall went from 1 to 9 Ties Blom

Would it not make more sense to use set-based logic to do this? Do the records have an unique identifier? You can define a view against the table that stores the records / identifiers that qualify for most recent date per item/customer. Flag the records (by update) for deletion that are not...

Cognos Report Studio is a BI tool , not a SQL generator in the sense you are after. However there are ways to circumvent this. You basically fetch all columns from the customertable , put them in a list and use conditional formatting to show/hide the list columns. Another approach (if you can...

Cognos .. Stitch queries.. Love 'm. Still king of the hill in resolving multifact scenario's. Ties Blom

I'd say this is no bridge as it does not fit into many to many resolvation. Any drawbacks by using the composite product-warehouse key for an additional product-warehouse dimension? Like generating a cartesian product between product and warehouse (all combinations), lookup keys and add...

Yes, if you decide to use native functions (and make sure to publish the db function set) . We stick to using Cognos functions as much as possible to ensure database independency.. Ties Blom

Within Report Studio you can acces all available Cognos (and Native ) functions. I do not think there is a Cognos function for either left or right padding, but you can work around this by using a case statement: CASE WHEN CHARACTER_LENGTH([SOMEITEM]) = 1 THEN '000000000'||[SOMEITEM] WHEN...

The open source community uses mostly MySQL , the opensource version of Pentaho PDI only needs to be unzipped to a location. PDI works with 42 different databases , so you can pick your choice. No, there is no such thing as 'a' document for deploying a datawarehouse. There are lots of books...

ToText and ToNumber functions should be the CAST function in Cognos. The & can be substituted with || I have no idea what you mean with "0##########" Is this some sort of formatting? Ties Blom

The solution to this problem takes a very different route. Instead of hiding/unhiding individual columns within the list , use 2 seperate list , or even use 2 seperate report pages , making sure to render the list/ page based on the proper logic. Obviously this requires 2 sets of query...

When budget is tight and you want to prototype from scratch I would recommend you check out Pentaho community editions of both ETL and Analytics. Currently working with PDI (Pentaho ETL solution) which is such a real pleasure to develop with. It compares favourably with - for instance - SSIS and...

The 'best' would depend on a host of factors, many of a non-technical nature. Your question is a bit vague.. Are you asking whether you should go for a one-shop solution? Ties Blom

A Crosstab is build from intersections, so all projected columns are the same, clicking the 3rd column is essentially the same as clicking any of the other 3. The column principle itself does not really exist within the crosstab (as opposed to a list) You would need to use drillthroughs from a...

I would add the HTML definition in a standard report, then add a new portal page to connection to show this report in a report viewer (see portlets) Ties Blom

Not sure about some of your enhancements, but in any case adding a value for a defined filter is a breeze. You simply select the item from the model and use the list option to select 1 or more values. Absolutely not required to know values upfront!! Toggling structure and data view is a bit...

With just 5 values, can't yo not just 'or' like: If(([Phr NPI]='1073861118') or ([Phr NPI]='1073861118')) THEN ('PREFERRED') ELSE ('NON-PREFERRED') = example for 2 values Ties Blom

Why not use 'in' instead of 'inlist'. No idea where you are working with though.. Ties Blom

[bigglasses][thumbsup2] Ties Blom

Code for what? You will need to establish first what data would be required to build the DSS against. Do you need to set up a datawarehouse from scratch? Does the information required already reside in an existing DWH? In the latter case is it required to build a DSS datamart or cubes as a...

AFAIK Cognos uses the SQL equivalent CASE and IF THEN ELSE syntax. The CASE approach is very much equivalent with the ANSI-SQL 'CASE' syntax: CASE WHEN <<BOOLEAN EXPRESSION 1>> THEN <<VALUE2>> WHEN <<BOOLEAN EXPRESSION 2>> THEN <<VALUE2>> ELSE <<VALUE3>> END The ELSE part is optional and...