Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. blom0344

    Repeating query not running faster

    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
  2. blom0344

    Check for multiple records.

    ...actual deletes on the table by using the flag Update the remaining records with the header date. Example for the view select statement: select * from detail_file df1 inner join (select df2.customer as c,df2.item as i,max(df2.date) as d from detail_file df2 group by df2.customer,df2.item)...
  3. blom0344

    Dynamic SQL for Report Studio

    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...
  4. blom0344

    Attributes of two dims in an N dim fact table

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

    Attributes of two dims in an N dim fact table

    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...
  6. blom0344

    creating fixed length fields in Cognos

    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
  7. blom0344

    creating fixed length fields in Cognos

    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...
  8. blom0344

    How to choose solution

    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...
  9. blom0344

    creating fixed length fields in Cognos

    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
  10. blom0344

    List not aggregating correctly in Cognos 8.4.1

    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...
  11. blom0344

    How to choose solution

    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...
  12. blom0344

    How to choose solution

    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
  13. blom0344

    Drill Through from Cross Tab to List with Static/Hardcoded Parameter

    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...
  14. blom0344

    add new page to cognos connection

    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
  15. blom0344

    Cognos Application enhancement proposal

    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...
  16. blom0344

    IF statement using an operator that evaluates against a list

    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
  17. blom0344

    IF statement using an operator that evaluates against a list

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

    how to develop decision support system (DSS) with open close principle

    [bigglasses][thumbsup2] Ties Blom
  19. blom0344

    how to develop decision support system (DSS) with open close principle

    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...
  20. blom0344

    IF AND STATEMENT

    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...

Part and Inventory Search

Back
Top