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!

  • Congratulations Mike Lewis 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: *

  • Users: cncom
  • Order by date
  1. cncom

    Powerplay : request between several cubes

    SPI33 - I was thinking along the same lines as GJP with my interpretation of your question. Do you mean virtual cubes or whether COGNOS can extract data from Essbase/DB2 etc? <><><><><><><><><><><><><><><><><><><><><> COGNOiSe.com The world's first dedicated COGNOS portal
  2. cncom

    Run CRN report in multiple databases

    You can't dynamically change the database that the report will use. However you can define it within Framework Manager. Under datasource in FM, you can change the database schema to the different systems you want. Or you can change the connection in Cognos Connection -> Directory -> Data...
  3. cncom

    Powerplay stops automated cell update for formulas

    Can I ask a silly question (or two): - is the 'recalc(F9)' option selected in Excel? - in Powerplay : what is the setting on EXPLORE>GET DATA>? Thanks, <><><><><><><><><><><><><><><><><><><><><> COGNOiSe.com The world's first dedicated COGNOS portal
  4. cncom

    Formatting for Excel

    Hi datawrangler, I agree, this line break/blank is a long standing issue. I did try a dummy dimension but it is not a sustainable outcome. I suspect that one way is to manually configure the xml (PPX) file but I am not sure how the cognos parser treats it. Great post on a fiddly hair-tearing...
  5. cncom

    IWR drill thrus

    I had a similar issue but it was an Acrobat version issue. Was the SOE upgraded recently? <><><><><><><><><><><><><><><><><><><><><> COGNOiSe.com The world's first dedicated COGNOS portal
  6. cncom

    finance/consolidation

    We have it. It's been OK - a few user issues initially. Were you interested in any particular aspect cogdev1? <><><><><><><><><><><><><><><><><><><><><> COGNOiSe.com The world's first dedicated COGNOS portal
  7. cncom

    Color coding in crosstab in ReportNet

    Hi pjazwier, Try this link: http://cognoise.com/community/index.php?topic=43.msg169#msg169 <><><><><><><><><><><><><><><><><><><><><> COGNOiSe.com The world's first dedicated COGNOS portal
  8. cncom

    Impromptu Web print report and subreport with 1 click

    Hi Sagae, Do you mean you wish to use the C# front end to pass eg. URL parameters to the COGNOS server (much like, and instead of, the Impromptu report prompts) to get to the final drilldown report? <><><><><><><><><><><><><><><><><><><><><> COGNOiSe.com The world's first dedicated COGNOS portal
  9. cncom

    CRN: view generated sql in ReportStudio

    timida, looks like the only way to do it is to 'trap' the SQL at each query - which is not really practical. i checked with my team and we all came to the same dead end. love to hear if anyone else was able to come up with an alternative. cheers <><><><><><><><><><><><><><><><><><><><><>...
  10. cncom

    CRN: view generated sql in ReportStudio

    ..oops sorry timida - i missed the second part of your post. Will have a quick look on the prompt SQL and get back to you. <><><><><><><><><><><><><><><><><><><><><> COGNOiSe.com The world's first dedicated COGNOS portal
  11. cncom

    CRN: view generated sql in ReportStudio

    Hi Timida, - click on your Query Explorer - select the tabular model for your report - click on 'Generate SQL'in the properties window at the bottom-left of your screen Hope it helps. Cheers <><><><><><><><><><><><><><><><><><><><><> COGNOiSe.com The world's first dedicated COGNOS portal
  12. cncom

    CRN - making a proper framework-model

    Hi Timida, Are you able to give more information about current model and reports required? Cheers, <><><><><><><><><><><><><><><><><><><><><> COGNOiSe.com The world's first dedicated COGNOS portal
  13. cncom

    'na' randomly appears in Powerplay

    Hi RNRM, Does it happen : - on any particular report or section of the report? - for a particular cube? - is it web or client? workstation (environmental)? - anything peculiar about your cube builds or overnight refresh? Cheers, <><><><><><><><><><><><><><><><><><><><><> COGNOiSe.com The...
  14. cncom

    How did you handle complex queries in ReportNet?

    tbt103, When we rolled out ReportNet, we identified our Power users from the Business Units. As a prerequisite, they had to be proficient Excel users (some VBA or some knowledge of the functions). We then put them on an extensive Report Studio course and then followed up periodically. We found...
  15. cncom

    Report Net Drill Down

    TheShenkler, Linked reports, or drill through reports allow you to see more detail on a particular area of interest. You can create a drill through report by adding a parameter to a child report and a drill through connection from the parent to the child. Note : a filter must exist on the...

Part and Inventory Search

Back
Top