Thursday, October 1, 2009

I'm Back Doing Cognos Again

Hi all!

after a 6 month pause I'm back working with Cognos again.

Please expect some posts on how to build a dashboard and how to solve incremental cube building with Transformer.

Sic.

5 comments:

  1. Any chance you'll do a post on semi-additive fact? We have 800,000 products on 500 locations and would like to maintain on-hand balances daily.

    Do you know if 'last period' aggregate rule in FM work for missing rows?

    Great site - thank you for sharing your knowledge.

    de Silva

    ReplyDelete
  2. cognos is changing course on every release as speak, thus, do you think you will publish your " Cognos Book" anytime soon? :)

    ReplyDelete
  3. No... it won't come anytime soon.

    ReplyDelete
  4. Any comment or tips for setting up default schema for tearadta data source in congnos connection. SQL server just work fine but having issues in teradata. Many companies have different database/schema name across environment. e.g. pubs_dev, pubs_test, pubs_prod. I don't want to change schema name in FM everytime I deploy package from one environment to another.

    ReplyDelete
  5. on 8.3 it is easier to deal with multiple environments than on 8.2
    I don't know about 8.4
    One thing to consider is how many Cognos environments do you have.
    If you provide more details I may be able to advise you further.
    Easiest is to keep the Cognos datasource name and just switch where it points to... but that may not work for you if you need DEV, TEST, PROD etc. simultaniously

    ReplyDelete