Veröffentlicht am

Berechnung: Mitglieder / Ebenen mit einem statischen Text ergänzen

 

Die Anforderung:

Aus einem dimensionalen Modell sollen die Texte der Mitglieder mit einem Text ergänzt werden.

Z.B. Die Produktnamen mit dem Text „Produkt: “

 

Da Mitglieder vom Datentyp keine „Texte“ sind, muss hier entweder mit einem Attribut der Ebene gearbeitet werden oder über eine Funktion die Mitgliedsbeschriftung (Titelzeile) ausgelesen werden.

Das geht z.B. mit der Funktion „caption“. Die Berechnung sollte dann so aussehen:

 ‘Produkt: ‘ + caption( [meine Kateorie oder Ebene] )

In Report Studio / Analytics Berichtserstellung und Listenberichten geht es vielleicht noch einfacher:

Mit dem geöffneten Schloss kann in die Spalte in der das Datenelement ist einfach noch ein Textelement einzufügt werden.

 

 

Veröffentlicht am

Aktuelle Cognos Analytics Version Juli 2017 (11.0.6, 11.0.7, 11.0.8)

Momentan ist noch die Version 11.0.6 die aktuelle Version von IBM Cognos Analytics.

Hier gibt es aber auch schon ein Interim Fix 1. Inhalt sind Verbesserungen der Maps (Zuordnung von Postleitzahlen, Namen der Positionen). Details siehe hier.

In ein bis zwei Wochen wird aber wohl schon die Version Analytics 11.0.7 erscheinen und dann recht zügig im September 2017 die Version Cognos Analytics 11.0.8.

Es wird also noch viel Entwickelt und wir freuen uns auf neue Features und Verbesserungen.

Veröffentlicht am

Cognos Analytics Filtertexte im Bericht anzeigen

Schon in Impromptu (das Cognos Reporting Tool aus vergangener Zeit) war es möglich den Text eines Filters im Bericht anzeigen zu lassen.

In Report Studio wurde diese Funktion vermisst.

In aktuellen Versionen von IBM Cognos Analytics ist dies nun wieder möglich:

Einschränkung: Einigermaßen sinnvoll funktioniert das nur bei benutzerdefinierten Filtern. Bei Filtern über den Ausdruckseditor erscheint nur der Text: „Es wurden ausdrucksbasierte Filter angewendet“.

 

 

 

Veröffentlicht am

Cognos Analytics: Datenquellen für das Web-Modelling freischalten

[av_textblock size=“ font_color=“ color=“]
Ab Cognos 11 (Cognos Analytics) haben BI Anwender (ohne Zugriff auf den Framework Manager) Modelle – Datenmodule – für relationale Datenbanken zu erstellen.

Damit aber Datenquellen auf relationale Datenbanken für diese Modellierungsart freigeschaltet werden, müssen in der Cognos Administration die entsprechenden Datenquellen für die Webmodellierung freigeschaltet werden.

Hierzu ist in den Eigenschaften der Datenquelle unter Datenquellenfunktionen / Berichtserstellungsverbindung zulassen der Haken „Webbasierte Modellierung zulassen“ anzuhaken.

Cognos Analytics Webbasierete Modellierung zulassen

[/av_textblock]

[av_icon_box position=’left‘ boxed=“ icon=’ue81f‘ font=’entypo-fontello‘ title=’Tipp 1 – Migration‘ link=“ linktarget=“ linkelement=“ font_color=“ custom_title=“ custom_content=“ color=“ custom_bg=“ custom_font=“ custom_border=“]
Nach einer Migration von Cognos 10 auf Cognos 11 ist diese Option deaktiviert. Die vorhandenen Datenquellen stehen also erst mal nicht für die Webmodellierung zur Verfügung.
[/av_icon_box]

[av_icon_box position=’left‘ boxed=“ icon=’ue81f‘ font=’entypo-fontello‘ title=’Tipp 2 – *.jar Files / JDBC Driver‘ link=“ linktarget=“ linkelement=“ font_color=“ custom_title=“ custom_content=“ color=“ custom_bg=“ custom_font=“ custom_border=“]
Werden die Datenquellen dann angezeigt, aber der Zugriff ist immer noch nicht möglich, dann kann dies am JDBC Treiber liegen.
Die Treiber müssen für Cognos Analytics 11 auf dem Server in das Verzeichnis install_location\drivers kopiert werden. Danach die Cognos Dienste neu starten.

[/av_icon_box]

Veröffentlicht am

Video: Dashboards erstellen mit IBM Cognos Analytics – Cognos 11

[av_textblock size=“ font_color=“ color=“]
IBM Cognos Analytics (Version Cognos 11) bringt ein komplett neues Frontend für den Benutzer mit. Die Berichtserstellung und Datenanalyse erfolgt über eine integrierte Oberfläche im Webbrowser.

In diesem Online-Video zeigen wir die Schritte um ein kleines Dashboard auf Basis einer Excel-Datei zu erstellen. Die Daten werden hierbei vom Anwender auf den Server geladen und in einer animierten Balkengrafik angezeigt. „Video: Dashboards erstellen mit IBM Cognos Analytics – Cognos 11“ weiterlesen

Veröffentlicht am

Cognos Analytics ist neue moderne Frontend für die schnelle Berichtserstellung

Der Zugriff auf die Daten erfolgt wie bisher über die Cognos Packages (z.B. aus dem Framework Manager) oder direkt auf eigene Datenquellen wie Excel Dateien.
Der Anwender benötigt also nicht in jedem Fall die Unterstützung der IT Abteilung um eigene Daten auszuwerten.

Wie bei der Fachmesse IBM Insight 2015 in Las Vegas klar wurde fokussiert sich IBM im Bereich Datenanalyse immer weiter auf Big Data und Analytics, Künstliche Intelligenz, Deep Learning und Cloud Computing.
Realtime Reporting und realtime Analyse soll nun mit Cognos Analytics möglich sein. „Cognos Analytics ist neue moderne Frontend für die schnelle Berichtserstellung“ weiterlesen

Veröffentlicht am

Welche Cognos Version ist installiert?

Bei den ganzen FixPacks, Updates und schnellen Versionszyklen kommt man schon mal durcheinander welche Version von IBM Cognos BI gerade installiert ist.

Es gibt zwei Quellen um an diese Inforamation zu kommen:

  1. in dem Installationsverzeichnis von Cognos befindet sich eine Datei mit dem Namen cmplst.txt
  2. in Cognos Configuration erhält man mit der Tastenkombination CTRL-H ein Fenster mit einem Tab „Installierte Komponenten“
Übersicht der installierten Komponenten von IBM Cognos abrufen.
Übersicht der installierten Komponenten von IBM Cognos abrufen.

Die Informationen in den Dateien sind zwar auf den ersten Blick nicht sehr übersichtlich, aber man kan hier die Versionen recht gut zuordnen.

Hier die Liste bis zu der Version 10.2.:

„Welche Cognos Version ist installiert?“ weiterlesen

Veröffentlicht am

Datum aus PowerPlay Cube im Report Studio Bericht anzeigen lassen

Wer das Erstellungsdatum eines Würfels aus dem PowerPlay Transformer in Report Studio Berichten anzeigen lassen möchte benötigt eine Layout-Berechnung.

Die Funktion die einem direkt ins Auge springt ist die „CubeCreatedOn“ Funktion. Diese zeigt bei PowerCubes aber nur eine leere Zeichenkette.

Die richtige Funktion ist die „CubeUpdatedOn“. Die Funktion erwartet einen Parameter in der eine Dimension übergeben werden muss.

In dem Beispiel wurde hier die Zeitdimension „Jahre“ gewählt:

CubeDataUpdatedOn( [auf_verkauf].[Jahre] )

CubeDataUpdatedOn

Veröffentlicht am

IBM Cognos BI 10.2 erschienen (Download / FixList / Neue Features)

Nun steht die neue Version 10.2 von IBM Cognos BI zum Download bereit. Es gibt eine lange Liste von behobenen Fehlern und ein paar neue Funktionen. Schnell auffallen wird die Umbenennung einiger Komponenten. Wie war das doch gleich mit den Namen „Cognos Insight“, „Cognos Business Insight“, „Cognos Business Insight Advanced“… so viel Insight, dass man gar nicht wusste welche Komponente nun gemeint ist.

So sieht es nun in der Version 10.2 aus:
– „Business Insight“ nennt sich nun „Cognos Workspace“
– „Cognos Insight“ ist weiterhin die Cognos Clientvariante auf  TM1 Basis

Erwähnenswert ist das „Skin Management Utility“. Hier kann nun das Corporate Design visuell entworfen und in die Cognos Oberfläche eingebunden werden. Damit wird das lästige Stöbern in den verschiedenen XML-Konfigurationsdateien minmiert.

Was es alles an neuen Funktionen gibt kann hier nachgelesen werden: New Features in Cognos 10.2.0

Der Umstieg lohnt sich. Zur Veranschaulichung hier die beachtliche Liste behobener Fehler von der Version 10.1.1 des BI Servers:

  • Casting a datetime object against oracle into a Varchar returns an incorrect year when year is 2050 and beyond
  • Informix: Data inconsistancy because OUTER join executed as INNER join
  • Filtering Access date fields using date functions is not consistent
  • Slicer ( using a prompt macro to make optional the slicer filter ) powercube report ´s crashing when drill-ups
  • cut and paste a report to override existing report fails
  • Set Prompt Values for Report View running against Planning – Contributor Data source results in OP-ERR-0068 Logon failure.
  • Editing drill through definition target gives error if mapped dataitem is located under a folder: MQP-ERR-0015
  • Using Nested Sets inside Nested Sets genrates no ( NULL ) values for custom rank on 3rd level of the same dimension
  • Unable to change the Drill-Through Definition for DMR with Shortcut: MQP-ERR-0015
  • Upgrade 8.2 to 8.4 generates DPR-ERR-2077 causing dmp files in bin
  • Drill through using in_range on formatted attribute no longer works
  • Distributed install: system status for all the dispatchers and services are Unknown
  • Page Caching problem
  • DPR-ERR-2072 error on report with conditional block on prompt page
  • UI doesnt enable administrative access to users personal Alerts for Directory Administrators
  • QE-DEF-0261 – Report worked in 8.4 GA, doesn’t work in FP1 or FP2
  • Unable to define data source to password protect cube
  • Group by not being sent to the database
  • Year(Date) calculation in Query Studio converts year to a comma separated format
  • DPR-ERR-2065 when filtering in Query Studio for specific characters
  • OP-ERR-0181 error message while running the report against MSAS 2005
  • Search and select prompt with multiselect behaves differently when report is run interectively vs in backgroud
  • Unable to save prompts in report view with an html item
  • unable to save to filesystem when prompt data contains a null
  • Numerous errors of problem reconfiguring handler TotalHandlernull javas.lang.NullPointerException
  • Report upgraded from 8.3 fails with OP-ERR-0025
  • „The converter failed to open the file“ when report containst URL with a space
  • Dividing an interval returns wrong result
  • Analysis Studio shows blank cells when run in any format with nested measures as columns
  • ps.Validator warnings in cogserver.log during portal page navigation
  • prompt value is passed incorrectly in a report view
  • CM consistency check history update for multiple namespaces fails with „CM-SYS-5001“: NullPointerException contentTask.java:1127
  • BmtActionsHelper.cpp(475) error in Framework Manager when adding a static Query Item
  • Unable to use Swedish Characters in Prompt buttons
  • Different Result after Upgrade from 8.2 to 8.4
  • _add_days giving inconsistant results when _day_of_week used to calculate # of days to add
  • Crosstab against DMR shows empty when child member is dragged under parent were no values in db
  • CASE WHEN calculation not working on PowerCubes/SSAS Cubes
  • Chart title cannot be made italic / bold with certain fonts i.e. Tahoma
  • IE script error when using % in Search &Select prompt
  • CNC-MON-0018 The restart failed
  • Error running report in folder containing certain French accents after applying FP5 for 8.3 BI
  • RSV-VAL-0010 validation error after upgrade from 8.2 to 8.4.1
  • Conditional Palette using median() function gives QE-DEF-0359 error
  • CSS is invalid in 8.4.1
  • Aggregate function and custom views results in #!Security error
  • Row populating incorrectly in crosstab report after upgrade
  • Bibus Process memory exhausted when Don’t Print class set for Page within RS.
  • Drill through from PDF output saved locally and opened in browser results in JavaScript error on page.
  • Table Of Content page has incorrect page number linked in PDF format
  • charts – horizontal alignment property not working for axis labels
  • (+) icons are displayed on Analysis Studio although they do not have any further sub content
  • Unable to access query subject that is select with Session Command blocks to DB2 (UDA-SQL-0196)
  • _add_days function not dealt with consistantly for DB2 data source with DB only processing
  • Error RSV-BBP-0028 when expanding a tree prompt of a report in a portlet
  • CM-SYS-5001 error when deploying report with large number of report output versions and size
  • Drill through from specific cell in Analysis Studio to Report Studio report, adds a space at the end of parameters.
  • RSV-SRV-0040 while navigating through interactive html output
  • PCA-ERR-0062 The „propertyValue“ node is not expected to be a „value“. Crosstab upgraded from 8.2 to 8.4
  • Missing values in crosstab after upgrade from 8.2 to 8.4.1
  • Core created when running a report to PDF
  • Report containing column sorted in descending order errors
  • PDF and Excel 2007 are rendering incorrect font output for barcode fonts
  • Event Studio: Unable to resize frame when using FireFox
  • User sorting ( all COGNOS releases ) based on roleValue function is not honoured: _memberCaption is used instead.
  • “Excel found unreadable content in..” when opening a multi-list report with one empty list enclosed in a block.
  • Chart report with negative values causes error CGS-PG-2001
  • Relative Alignment for Text Prompt Control is not working when report is run
  • Removing locales from Cognos Configuration causes Polish named functions
  • Set prompt values for a report running against Planning – Contributor Data source results in OP-ERR-0068 Logon failure.
  • SBW-ERR-0019 when selecting „earlest date“ or „latest date“ on a optional date interval variable.
  • If-then-else with current_date gives incorrect result
  • Setting query subjects to use native SQL in FM causes split select statements in the native SQL for report studio.
  • The measure on tooltip of line graph is unable to show correctly
  • Measure cells show empty (ALL COGNOS releases) with nested totals when slicer with EXCEPT function is applied to a projected ragged hierarchy.
  • List data lost when page up link pressed in html report.
  • Macro replacement with ParameterMap based on SQL inside an OLAP query is not working.
  • On MSAS 2005, no error is returned when the Maximum Rows Retrieved Value is exceeded
  • Internet Explorer hanging when editing a large number drill though definitions in Cognos 8.4.1 FP1, same behavior does not happen when using Firefox
  • The letter ‚T‘ in timestamp
  • QE-DEF-0149 Incorrect Query Specification when searching for a double space in search and select prompt
  • QE-DEF-0467 Error when executing ANS with combined Xtab and Chart
  • Incorrect string displayed under „Defaults for all steps“ when creating a job
  • Null values not working for prompt values in schedule
  • Core Dumps are generated after certain period of time – Bibus Hangs
  • Ancestor function returns NULL member
  • Report List with prompt values generates the following message when placed on Insight
  • QE-DEF-0260 RSV-DEF-0261 in business insight advanced when selecting create custom filter.
  • Incorrect page numbers in Table of Contents in PDF
  • parameter $RunLocale returns wrong language when used in measure expression
  • Only 1-2 trend lines displaying when there is a nested series in scatter chart
  • QE-DEF-0359 when validating an upgraded report in Cognos 10
  • Editing invalid expressions has a very long lag time
  • Getting FATAL ERROR: ‚java.io.FileNotFoundException when creating new style using stylemgr tool
  • Canceling and Resubmitting Report Prompt Returns Incorrect Query Results
  • Tree Prompt For Report Studio Report Empty in IE Browser
  • Multi-tab Dashboard with Safe Mode Viewer portlet do not end
  • Chart and crosstab don’t render properly aftr upgrade
  • How to add an image/logo to the top left hand corner of the Administration page in Cognos 10.1.
  • German translation with missing capitalization
  • Report upgraded from Cognos 8.3 to Cognos 10 fail with error PCA-ERR-0064
  • Extra total line is being added to report upon DQM upgrade
  • XQE-WRN-0022 Unbalanced members may not be projected for the path of dataItem during validation should not be thrown
  • Reports run interactively from View Report Output Versions, create reportname containing garbage symbols
  • report shows two lines in the same size in a portal tab even the size properties is different
  • Aggregation Rules cause poor report performance in Cognos 8.3
  • Pie chart labels cut off in HTML
  • Format option not retained when Scheduling capabilities restricted
  • When using large numbers defined as decimal, data will be truncate the last digit will be pad with 0
  • Upgraded 8.3 report gives OP-ERR-0144 on validation and OP-ERR-0025 on execution when using two items on a multi-select prompt
  • PRS-TRS-0906 error adding a hyperlink to the body of an email sending a report
  • CAM_LPSvr processes are orphaned after shutdown
  • Using style manager to modify the skin color in Cognos10.1 results in a white band
  • unexpected value when applying the % of total at calcuted column
  • Report runs however does not validate. XQE-PLN-0001 Internal error.The query could not be planned by the Query Service
  • drill down using alias shortcut within Crosstab gives error RQP-DEF-0523
  • C10 under Firefox does not resize window
  • The prompt uses prompt macro does not populate data in Cognos 10 after upgrading from Cognos 8.4.
  • CPS-CCM-1204 in Sharepoint when inactivity timeout is reached.
  • Unable to cast datetime as time using teradata datasource.
  • Scroll left and right stop working in multipage portlets
  • 10.1 FP1 :: Essbase 11.1.1.3 – Reports w/ Substitution Variables run slow
  • ‚contains‘ does not work properly in a detailed filter
  • User unable to run reports when user only has Traverse permission on the top level Data Source directory.
  • Percent scale doesn’t work in column chart.
  • Value if NULL funcationality does not work in some cases
  • Multi-page portlet no longer resizes width in Cognos 10
  • The behavior of creating a new folder is wrong when pressing key
  • Reportname function is not reflected when browser locale is changed
  • aliases in dimension. the query generates a group by in sql
  • Customer is unable to integrate search provider with Cognos Index Search
  • Replace the IBM Logo with a Custom Logo greater than 35 pixels in height
  • Transfotmer 8 failed to create cube at TR1916 if data source contains user defined characters in PUA of Unicode table planes 00.
  • Crosstab column header in CSV report shifted when RSVP.CSV.REPEAT_XTAB_LABELS is set to true
  • Mouse-hover over line markers not working on Cognos 10 FP1
  • Baseline of x-axis in excel format report is not same with HTML report.
  • Running PPX_UPGRADE.MAC Gives no Results
  • Drill through to Operational Report does not use any of the parameters passed from the source Analytic Report
  • Conditional layout does not preserve drill down data
  • Cognos 10.1 Migration Assistant Tool for Series 7.5
  • CCP-SP-0005 when running statistics report with empty resultset
  • Default range for a range value prompt is not set correctly unless a Finish or Submit button is pressed
  • No C10 bar chart generated when specific level in powercube used.
  • Running Report Based of MSAS 2008 gives OP-ERR-0175
  • QE-DEF-0260 Parsing error before of near position : following upgrade from 8.2 to 8.4, 8.4.1 or 10.1
  • IR: Is there a way to avoid proxy URLs when clicking How-to video links in 10.1?
  • User cannot see full decimal places when they run list report as Excel 2007 format.
  • Setting query for „Use Local Cache“ causes reuse of initial prompt values
  • The logon / logoff is not recorded in the COGIPF_USERLOGON table
  • Using a CJAP if you log off then log back in while on a custom page with a cognos viewer you get AAA-AUT-0011 error
  • „Internal Error – Request failed“ saving cube view as PDF on Solaris 32-bit
  • Transformer auto signon not working in batch when the password saved in the model contains special char ‚&‘. Log shows TR3703
  • Unable to enter [ (left square bracket) character using [AltrGr]-[f] in Report Studio with Slovenian language setting
  • With DQM enabled, a report returns an error: „XQE-PLN-0006 Internal error“
  • Upgraded report fails to run in IBM Cognos 10.1 – Getting the error of : PCA-ERR-0038
  • Datasource connection with period in name will not open in FM.
  • Search &Select prompt can be used even when required cascade prompt has no selection made
  • Query for history[last()] doesn’t bring back a result although histories are existing
  • „Run with advanced options“ prompt page executes in language listed last on „Select the languages“ page
  • Error running external data sources with Dutch Regional settings
  • Under specific conditions, a Model Query Subject causes Framework Manager to crash
  • Display drill context in title
  • Unable to open filter dialog when double-click on detail filter
  • Custom calendar files generated in 8.1 and which load successfully into 8.1 fail to load in 8.4.1.
  • Using xtrViewStatus.trViewStatusClear is not working on the object categories anymore.
  • Native Type on VVM is difference with SAP and imported data does not show up properly.
  • ReportDataService (RDS) Governor Limit settings do not work for Analysis Studio or Report Studio reports
  • In Report properties, the Run history and Report output versions in mixed up
  • mentioned in Install &Configuration Guide is incorrect to setup apache 2.0 module
  • Query for a Novell eDirectory group does not give back consistent result
  • Unable to insert existing query dataitems as second chart series in IE8
  • Maximum execution for report service with Analysis Studio
  • Unable to save package with External Data Source when original package is in My Folders.
  • Drill-through to bookmark fails when source data Item Value does not match target dataItem
  • Cannot expand dimension in Data Tree in Studios
  • Documentation Bug: advanced parameter lotus.compatibility.mode translated in french to mode.compatibilité.lotus
  • Changing language mappings in CogConfig shows Czech language folders in ReportStudio
  • VVM trying to pull data from SAP and error occurs.
  • Bevel setting functionality breaks in IBM Cognos 10.1 FP1
  • Consuming Report in Business insight cause a Java issue „Expected ‚}‘ “ if the report data contains quotation marks in the text.
  • Special Category ( child ) not displayed on C8 studios even when Inclusion is set to „always include“
  • A report with Tree Prompts that reference session parameters works in 8.4.1 but throws RSV-BBP-0028 error in IBM Cognos 10.1
  • Setting scaleOfFloatDouble in qfs_config.xml, wrongly affects to a decimal type of measure used in crosstab
  • Cannot override report options in Event Studio with FireFox 3.6
  • After upgrade from 8.3 to 8.4.1 wrong figures appearing with context filter in Anlaysis Studio
  • Different iterations of same scheduled reportView yeild different data for unchanged prompts/data.
  • Deleting not only descendant customs views but also ancestor custom views from PowerCube view
  • Cognos Lifecycle Manager – unable to see target report specification
  • Large images are no longer appearing in Excel 2007 outputs after upgrade to FP1.
  • Received Runtime Error while saving the imported map as cmf in Map Manager
  • Get SOAP error when chossing a query with Data item name containing ‚ or &in External Data Management.
  • 8.4 FP2 w/ Hotsites :: DPR-ERR-2077/DPR-ERR-2056 when running reports
  • Virtual View manager documentation error for Oracle jdbc driver install
  • Documentation doesn’t mention requirement to import SSL certificate manually to Framework Manager
  • After upgrade from CRN to 10.1 reports fail with QFS-ERR-0140
  • DPR-ERR-2088 Report Studio chart parts error on some BUX actions if the server group name contains spaces
  • Cognos 10 Chart is not refreshing after using Submit/Finish button
  • levelNumber is invalid for function SimpleCase in Upgraded C10 Report from Classic to DQM
  • levelNumber is invalid for function NotEquals in Upgraded C10 Report from Classic to DQM
  • java.lang.NullPointerException in Upgraded DQM Report
  • 10.1 :: FM import of BO Universe 12 – error [MBCM_E0015]
  • age function in report studio returns incorrect results on specific dates
  • Folder which contains Shortcut to Watch rule output can not be browsed in Business Insight
  • Drill-throughs from PDF do not work when there are multiple pages defined in the report specs and FULL PDF compression is enabled
  • Lifecycle manager unable to use value prompts set to radial groups
  • Charts in report displayed in cognos viewer portlet on Portal Page shows red X sometimes
  • Drill-down on attributes shows „=“
  • Deny of ‚Allow External Data‘ secured feature does not remove the ability to use external data.
  • Incorrect values in repot after upg from 8.4 to 8.4.1 FP3
  • DM-DBM-0400 and UDA-SQL-0353 Data Manager / Netezza : Relation ‚xxxx‘ already exists
  • Report running error after upgrade to C10
  • Unable to import report created in 8.4 into Cognos 10 for Microsoft Office.
  • Saving CSV report takes a long time when we turn on local cache
  • Pie Chart : performance issue using settings Values „Inside slices“ and Labels „Outside slices with lines“ in properties
  • In a portal tab the width of portlets doesn’t resize when window size was changed with IE
  • Custom login page with Internet Explorer doesn’t default to ‚OK‘ when hitting enter.
  • Error : ‚document.pform.m_name.value‘ is Null or not an object
  • Can not view target report specification in Lifecycycle Manager 10.1.1
  • When using the rollup function on two data items and allowing drill down. It produces an error:QE-DEF-0478
  • QE-DEF-0480 The operands of ‚[Camping Equipment__0] + [Golf Equipment]‘ cannot be converted to consistent dimensional object.
  • Japanese characters are corrupted in Audit DB and cogserver.log after migrating Series 7 Upfront contents to Cognos BI
  • Business Insight throws erroneous message when opening a workspace that contains a secured ASPX website
  • Unable to implement Custom Provider Debugging using AAA.properties
  • Cognos 10.1 + Display of dates/timestamps is wrong if content language is set to hebrew
  • Legends appearing overtop of chart when rendered to excel 2007 and opened with excel 2010
  • Incorrect default permissions on trigger.sh (no execute)
  • File name change for Disabling Core Dump Files
  • Arabic word wrapping issue in PDF format
  • Audit Database does not log Logon Actions when running scheduled reports.
  • Cognos 10.1 RP1: Activities chart missing axis labels in IE 8 and IE 9
  • Query Studio reports do not work if path contains Hebrew characters
  • DQM drillthrough unable to pass parameter value between BEx variables
  • Link query items using UNC or file:// syntax do not work in Excel 2007 format.
  • Unable to import a datasource file via Manage External Datasource in Report Studio, because axceeds the maximum number of rows
  • Transformer Deployment process will not stop and cube will be published even when data can not be found in the datasource
  • background.0 is null or not an object Javascript Error when clicking on Advanced Options with no scheduling capabilities
  • The following message: „I cannot resolve that dispatcher’s GUID.
  • 500 – Internal server error When Using 10.1 RP1 Cognos Office Connection
  • Convert a report to an active report save does not work
  • Javascript browser error in Query Studio when clicking Filter for report
  • When layout component reference and the override property are used, the ListBox sort order is reversed
  • Macro could not run using command-line „pwrplay.exe -m“
  • Getting error „CPS-PAG-4801 – Operation failed in the consumer component.“ on HTML Viewer
  • Excel Export not working in a distributed environment
  • Drillthrough MQP-ERR-0026 The members are unknown
  • Non-admin user can not install CAFE properly
  • Doc: Provide detailed information on search terms when using the Search facility in Cognos Connection
  • Missing duplicate rows in Cognos 10
  • undefined symbol: SQLRemoveDriverW using unixODBC 2.2.11 with MySQL 5.1 + MySQL Connection ODBC 5.1.5
  • Wide Performance difference between CQM and DQM
  • Dragging in a ReportView at the top level from My Folders, does not return in Business Insight
  • Deployment Export target location is not being saved properly
  • Changing Cognos configuration Global default font to Arial does not work in C10.1.1
  • Installing FM to a unmapped or supported locale results in mixed labels appearing.
  • Problem on upgrade from 8.3SP5 to 10.1.1 – Error on validation (QE-DEF-0459 CCLException)
  • Filter is not working after report upgrate from 8.3 to 10.1.1
  • Unable to open email mht files
  • Data row index is out of range
  • OR filter against multiple levels in a hierarchy
  • Total columns appearing in CSV output in C10
  • Deleted user’s bursted output is still visible in the Cognos Content Store.
  • Upgraded cube-based report returns different data
  • Can not use calculated measures in CAFE
  • Active report in iPad behaves differently then outside ie run locally
  • Unable to set active report to burst when added to job.
  • No error messages when datasource test fails DB2 version 9.5
  • 10.1 RP1 Error RSV-CCP-0005 and STS-CLT-0014 when temp files encryption is activated while trying to run statistics reports
  • Unable to launch Query studio saved report through „Pencil symbol“ in Cognos10.1 FP1 when report path is long
  • Unable to show negative values in brackets and in colour in Y axis for Chart
  • Prompted for uid/pw when modifying a schedule
  • Synchronized Drill Down
  • Select &Search prompt resets other prompts in QS report
  • Cognos 10.1 RP1 Mobile: Restricting Content Browsing or Searching documentation issue
  • PowerPlay Studio Export into Excel 2007 lead to be that the filter line will not be displayed completely in Excel 2007
  • Report with spaces seperated with + in 10.1.1
  • „Return“ button missing when opening Cube in PowerPlay Studio
  • Go Search Integration with Google OneBox appliance
  • CCL_ASSERT comboElementIndex error == m_legendComboElementVector.size error w\ chart containing nulls
  • CASE WHEN CAUSES REPORT SERVER TO CRASH AFTER UPGRADE TO 10.1.1: DPR-ERR-2056
  • Oracle error does show in data manager Log if „No Row Count Check“ is checked
  • Large Email Attachments in Excel/CSV is delivered as an empty 3kb attachment
  • Charts displays values in wrong order
  • 10.1.1 iPad Mobile: Second RDS server causes RDS-ERR-1000 / RDS-ERR-1020
  • Adding background images to reports causes different (sometimes erronous) results in Excel outputs
  • Documentation for Apache Web Server configuration for Cognos incorrect when using cognos_module for gateway URI
  • Charts in Excel 2007 and 2010 are not proper
  • Report does not return expected data based on specific filter condition
  • IR: Go Search errors irregularly
  • Auto-partitioning is not able to update the master cube of a time-partitioned PowerCube
  • JDBC Datasource connection fails with DQM and Turkish local set
  • Adding properties to burst group causes XML error on save
  • Applying sorting in C10.1 RP1 removes items that are in the query, but aren’t in the report.
  • Wrong slovenian translation in „IBM Cognos Administration“ portal
  • When defning „rows per page“, „more“ option is missing with Tree Prompts
  • Business Insight – lotus connections create activities window does not go away when BUX is embedded in an iframe.
  • Drill Through does not pass Parameters when „Open a new window“ is selected
  • Users receive „CAM-AAA-0056 Unable to authenticate.“ after update to 10.1.1
  • „One or more of the required values is missing. Required values are needed to produce the report.“ when selecting prompt
  • Executing report studio report using dimensions against Stored Procedures generate RQP-DEF-0036 error
  • The term „Unavailable“ should be used in the documentation
  • Warning message: RSV-RND-0004 Invalid CSS Declaration found ‚ color:transparent‘.
  • Invalid mime type with Excel 2002 outputs
  • Business Style ignores ‚Hide Border‘ property and always hides the borders
  • RQP-DEF-0114 The user cancelled the request when Choosing to view in excel 2002 and then clicking page down on original report.
  • New report engine tooltip shows wrong information,
  • Error message shows up after click validate button on DQM mode.
  • RDS-ERR-1036 The file „plugin/test.xml“ could not be retrieved by Report Data Service
  • DQM: Non aggregated value is not correct from 16 digits for Oracle DB
  • Documentation does not specify how to use Active reporting in IE7/IE8
  • truncate the axis value at C10 chart
  • The search path for //*[hasProperty(„active“)] returns an error
  • Lineage does not extend through query sets
  • RSDocIo:: read() not supported when secured data is being written
  • 30 user performance tests show performance degradation during the First Open.
  • Drill up/down behaviour not maintained with multiple connections to an Oracle 11G data source
  • Inserting the crosstab space causes RSV-SRV-0040 under DQM environment
  • Problem with Microsoft Outlook email and the Cognos Office Toolbar in Miscrosoft Office Word
  • Change in behavior after upgrade – Using Address URL to access Multi-Page Portal Tabs
  • Labels for graphs show as actual field name (query item name) not the actual display name
  • DPR-ERR-2056 when validating a master-detail relationship
  • RSV-SRV-0040 An application error has occurred, with XQECacheDataset::UNKNOWN
  • Documentation Error – „IBM Cognos User Interface and Error String Customization Toolkit – Version 10.1.1“
  • Slow performance when open, close, and save file in Go Office
  • Characteristic value ‚00000000000000000000000000000000‘ of characteristic ZYEQUIPNO is not ALPHA-converted .
  • Attempt to drill down from a chart in Business Insight fails: Drill Down is not available for the selected data.
  • Singleton not rendered in report after migrating form 8.4.1 to 10.1.1
  • 10.1.1 – spaces are replaced with plus signs „+“ when saving a report to excel
  • Report Administrator set up as a scheduling delegate shows other users as Unavailable in Schedules with series 7 namespace.
  • Filter values do not appear as subtitle.
  • Column applies Rank function does not sort correctly after upgrading to C10.1.0
  • Not possible to save reports locally under windows 7
  • Wrong aggregation against teradata after upgrade from 8.4.1 to 10.1
  • Find Report Dependencies in model with Union Query Set does not function correctly
  • Cognos can’t be started up if DB user name for Content Store includes underscore
  • Users with non-english content locale can not view run history nor open Report Studio.
  • Format of character measures from TM1 cube change if an item contains a local function
  • Problem saving Configuration with only PowerPlay Server installed
  • Error receives when come back from another portal tab in IE
  • Client is seeing QE-DEF-0459 DMB-ECB-0073 error validating upgraded report in 10.1.1 that worked in 8.2
  • Tooltips on Clustered Lines has no X/Y axis information After FP1 on 10.1
  • Drill in report upgraded to Cognos 10.1 RP1 not working as in the initial Cognos 10 release
  • Unable to open a Mailto: hyperlink when exporting a report to Excel 2007
  • Report drill-through doesn’t work in PDF but does work in HTML
  • Hierarchies do not support translations in C10.1
  • CM-REQ-4314 error on import of CRN deployment file in C10.1.1
  • Import a prompt report into COC, after choosing prompt values, the import is hanging at „Checking the system for prompts.“
  • „UDA-SQL-0458 PREPARE failed because the query requires local processing“ in BUX 10.1.1 while doing filter on the measure column
  • Query hint ‚Use SAP Member Cache‘ returns an error
  • SQL Server functions fails with RQP-DEF-0177 when run outside of a package
  • Report dependencies doesn’t work when uncheck maximum reports
  • DPR-ERR-2056 when using chart and Suppression Option Series
  • Box Type None is showing different result in HTML after upgrade to 10.1
  • Prompt Run button in Swedish changes from report design view to run view in Report Studio
  • crash the FM when publishing the package
  • Crosstab shows wrong value for interval (result of substracting two dates) when result too high (2^32)
  • Slow performance running report in background compared to running the report interactively.
  • Optional cascading prompts can’t be answered first when subsequent prompts hidden until active
  • Non-legacy chart with „Include Zero For Auto Scale“ set and all negative values causes bars to be displayed incorrectly
  • BIA report filters not editable when opened in Report Studio
  • Cond palette app for the 2nd needle in the series in a Guage Chart with inner and outer ranges does not take effect
  • cogtr -n2 command-line option does not work with SSO
  • Font formatin issue Cognos 10.1.1 Business Insight widgets title
  • Running ‚localize.sh generate‘ results in java class-not-found errors
  • An unknown error when Calculate Percent of base while Insert Rank in PowerPlay Studio
  • „Recalculate metric store derived values“ errors in 10.1.1 upgraded metric store
  • Large memory growth observed in the BIBusTKServerMain (32-bit) using Caspian 10.1.7006.504
  • db2loader , decimal seperator issue related to the regional settings on windows (SQL3122W )
  • Event Studio 10.1.1 does not work with SiteMinder: EMF_REQUEST error
  • Error message when trying to import external data
  • RSV-SRV-0040 When Running PDF Report With Option „Password to open report“
  • Combination charts not correctly converted to new graphics engine
  • The Write operation for the PDF output file failed error message when Encrypt temporary files is set to True in 8.3
  • Write permissions Dashboard reqd to delete (their own) comments that were just added in the same session.
  • Report causes environment to crash. Doesn’t seem to be same issue as previously recorded.
  • Human Task service and Annotation service failed to start on single server install
  • Unable to authenticate via SSO when External Identity Mapping replaced lowercase domain
  • ‚^‘ characters in MUNs cause drill up/down links to be disabled
  • DATA ITEM VALUE in LABEL of drill definition results in display of ‚Drill-Through Definition1‘ instead of value
  • 10.1.1: Schedules missed due to downtime are not executed upon service restore
  • Prompting – Tree – the tree image has changed and there are no end bracketts/lines to close the tree
  • Drill items not working &lineage error
  • Unable to open C10 Report in IBM Cognos for Microsoft Office – Error in XML Document
  • Cognos Content Administration Scorecard Page Inaccurate
  • Cognos Mobile: Location-aware Reports based on GPS coordinates
  • DPR-ERR-2056  The  Report  Server  is  not  responding. error after with distinct count in 10.1 to 10.1.1 upgrade
  • Report Studio report with advanced drill behaviour returns QE-DEF-0359 error when drill up
  • Expression editor causes Framework Manager to dramatically increase CPU usage
  • Securing Bux Integration of Tm1 Widgets with SSL does not work
  • Scrolling delay in Business Insight
  • Default Prompt Values in Cognos Office are not being used
  • Data Manager table selector for SAP/R3 crash frequently
  • Framework Manager Visual C++ runtime error when open project with security
  • Value prompt in layout component reference becomes optional with override enabled
  • Trendline calculation replaces NULL with 0
  • Apply sorting to a crosstab removes data items from query in Report Studion 10.1.1
  • Date filter conditional variable stopping the label on graphs from changing
  • cut and overwrite a package in another folder causes the report to loose his original package link
  • java.lang.NullPointerException when running Bursting in DQM
  • XQE-V5-0010 Syntax error found for data item. Invalid token „“ found after „Actua“
  • Editing schedule email distorts email text.
  • Adding crosstab spaces limits the number of custom drill-up/drill-downs that can be used in Report Studio
  • Lookup function fails with UDA-SQL-0013 Invalid native SQL on SunOS 5.10
  • Data Items in the specified Query seem to disappear when using burst option in report studio
  • Query Studio report with if using in_range crashes BIBusTKServerMain process
  • Format issue for member fact cells of crosstab space
  • DQA: Report outputs cannot be shown in environments with multiple servers
  • DQA: IBM JRE shipped is not used, or configured to be used
  • Framework Manager non-recoverable error with an xml datasource
  • Unable to utilise Style Manager on UNIX
  • Conditional formatting does not evaluate correctly large numbers when datatype is bigint
  • Preserve Functionality for drill behaviour is not working in 10.1.1
  • Report does not filter data properly when selecting same element name from separate TM1 dimensions
  • INCONSISTENT BEHAVIOR WHEN USING NESTED LAYOUT COMPONENT REFERENCES
  • Mail attachment limit setting does not take compressed attachment size into account.
  • Crosstab outer row edge data missing when selecting Bottom.
  • With ‘Maximum number of retrieved rows’ governor enabled, no error is shown in Query Studio prompt query
  • Unable to filter on attributes contained within a Query Items folder.
  • Date prompt doesn’t accept „Jan 1 1970“ as default date
  • QE-DEF-0467 error when selecting the highest value in the hierarchy slicer prompt
  • Internal customer report returning XQE-GEN-0010 Found an internal error: ‚one side of a join has not been analyzed‘
  • Drill down broken in new Charting engine
  • Report not rerun in Cognos Viewer in a page having navigator and viewer
  • Report cache causes RSV-SRV-0040
  • PDF security does not apply when running prompt report interactively
  • Cannot open Excel output when using a Cognos Navigator portlet
  • When one or more package-defined drill-through targets are not accessible, no drill-through targets appear in the list.
  • Excel 2010 charts don’t show negative bars
  • UDA-SQL-0107 error on reports upgraded to Cognos 10.1.1
  • Unable to view report output for report view from run history details of report
  • hotsite 10.1.6235.1028 causing BIBus crashes
  • RAC-CFG-0006 with zOS and TDS
  • Migration of Cube Views from Seris 7.4.4 to C10.1.1 failing
  • The images are missing in the CMM metric list portlet in Sharepoint.
  • Unable to change filter values in PowerPlay Studio
  • Rounded small negative numbers appear as 0.0 in PDF output and not -0.0
  • Documentation missing section on creating the HTS tables on DB2 for z/OS
  • After applying updater 10.1.6235.1099, QE-DEF-0030, QE-DEF-0359 are thrown when drilling up in a crosstab
  • Fatal error when deleting objects in Framework Manager
  • Business Insight: RDS-ERR-1057 when try to unfold a prompt.
  • Defect: Automatically generate footer summaries for measures doesnt works for calculations
  • Sort order titles not translated correctly.
  • Bibus does not get killed after canceling the report
  • ANS.DefaultVisibileItemCount setting
  • CM-CFG-5214 error occurs on standby Content Manager
  • Time Interval Cannot Display Values Beyond 48 Days
  • „Change Expression“ drill-down behavior results in a loop in expression when drill-to item is a descendant
  • OP-ERR-0181 error when running report
  • Thai characters appear as garbage in cogserver.log
  • DQA: Unable to expand folders. Axis Fault
  • Importing from AS400 using DB2 Connect fails with RQP-DEF-0177 and UDA-SQL-0107
  • After returning back from the target to source report, the default prompt selections are seen
  • Expanding a tree prompt throws an error in 10.1.1
  • ParamDisplayValue() shows trailing spaces
  • A report which reference hidden objects in a package still can run
  • Filter always OR filter when polish set as content language
  • CSV mimetype value is wrong
  • Drill down Chinese Character not working
  • Framework manager hangs after modifying a model query subject when using DB2 9.5 data source that contains multiple connections.
  • schedule – override the default values for prompt values generates XQE-DS-0002 intermittently
  • step 8 is redundant in Steps for Apache Server 2.2.x and IBM HTTP Server 7.0
  • HTTP Error 404 when using custom subsets
  • QE-DEF-0481 The expression ‚…‘ has a loop.
  • TR1106 Transformer 10.1.1 – When mdl is opened in Transformer
  • External identity mapping expression not working
  • Image shows as red cross in Active Report Prompt page
  • „open with report studio“ icon is missing for portlets with preferences different than english language
  • a11 c10.1.1 rp1 Captions on calculated members not being preseved on drill-down
  • User’s locale is defaulted to server locale after preferences change
  • Remove new feature ‚Adding non-numeric data in crosstabs‘ from documentation
  • SSO fails when using native IBM Cognos App version 10.1.1.3.1
  • Percentage of Base Calculation Not Available in C10.1.1
  • Failed to find file „/opt/app/cognos10/software/cognos10-1-1/samples/zipfiles/mpps-win32-gate-10.1.6235.600-inst.tar.gz“
  • Drill down/Drill up is greyed out for some items in a Cognos 10.1.1 report that is upgraded from C8.4.1
  • Not prompted for password when PDF is password protected in Report properties
  • Data items disappear when Grouping and Sorting is set on Page Sets
  • The error CM-REQ-4099 is generated when launching Query Studio
  • multiple report formats in UI when default report format is changed.
  • issue with drill through and prompt in dashboard
  • Wrong total displayed on Analysis with filter and nested levels
  • 10.1.1 RDS will display intrinsic values whilst user has active passport via http://cognos10/cgi-bin/cognos.cgi/rds/wsil/path/Public Folders
  • Layout Component Refererence fails in Active Report.
  • Active report: issue with the Data Radio Button Group and Data deck with the chart and 2 filters.
  • DPR-ERR-2056 and core dmp with multiple series on chart and supression enabled.
  • MSAS SSO – Error: AAA-AUT-0011 – Invalid namespace was selected. When SSO user logging off in QS
  • Drill down functionality disappears on upgraded reports
  • Unexpected behavior with “Allow the server to automatically load the file” enabled in external datasource
  • CM-REQ-4012 error does not appear when the user does not have the write permission to a specific folder.
  • Hyperlink images in Excel gives „Reference is invalid“
  • Cog nos do not compress attachments but sends attachment which has 0 bytes
  • Wrong language in lineage dialog
  • UDA-EE-0094 The operation „less“ is invalid for the following combination of data types: „character“ and „integer““
  • Regular user are able to cancel running schedules from other user and even from Administrators in a distributed environment
  • Framework Manager hangs on Publishing when parameter map contains ‚]‘
  • UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]The multi-part identifier „W1.C1“ could not be bound.
  • UDA-EE-0094 The operation „greater“ is invalid for the following combination of data types: „timestamp2“ and „character“
  • Servlet Gateway Fails to Start when Configured with BI, Metrics and Mobile in Single Server Installation
  • Query Studio stripping characters from query item name
  • ORA-24338 and UDA-CUR-0000 in prompt in Query Studio with Oracle proxy authentication
  • HTML Viewer in tab page does not accept URL with Chinese characters
  • Double report outputs for job with default options defined
  • Framework Manager immediately close when creating a measure dimension
  • Swedish language inconsistancy in 10.1.1
  • BmtActionsHelper.cpp(500): CCLUnknownError: CCL_THROW:
  • Encrypt temporary files causes saved HTML output to render slowly
  • Cannot create packages with External Data when package name contains square bracket characters [ or ]
  • QE-DEF-0405 Incompatible data types in case statement.
  • Defect: Screen and Syntax tip same for all functions in Report Studio
  • First drill up/down in the report is performed for all members on the crosstab edge
  • String containing a \ backslash character causes DPR-ERR-2101
  • RSVP.CSV.QUALIFIER only used when special characters in the queried data
  • The word ‚area‘ in graph causes it not to display
  • SAP BW XQE-GEN-0002 : …… Encountered: „[“ (91), after : „,“
  • Report with prompt causes select a signon loop in Business Insight
  • Multiple deadlock errors on content store after upgrade from 8.2 to 8.4.1
  • QE-DEF-0459 Linking report to an upgraded package.
  • xml and csv output differs from HTML output for List Report.
  • A detail filter and a slicer for the same dimension which is not projected are not merged together with an intersect
  • carriage returns removed from e-mail options dojo widget (Firefox only)
  • C10 Client Side Printing – severe printing performance problem with C10 report using C10 shipped font AndaleWT (Bold)
  • Doc: Remove Excel 2002 benefits from 10.1 User guide
  • CAMIDListForType causes QE-DEF-0406 error when tested
  • Behaviour change with cascading prompts (optional prompt and required prompt)
  • Report Studio report in Excel output displays (2.) instead of (2) for negative numbers
  • Value prompt size changes during reprompt when using IE and default height
  • UDA-EE-0094 The operation „condexp“ is invalid for the following combination of data types: „integer“ and „character“
  • When server locale is set to ja, some characters on Content Manager status check screen get corrupted.
  • QE-DEF-0299 error opening package with PowerCube and DB2 data source with ‚#‘ in schema name in Report Studio
  • Group Row is wrongly zero supressed in html format whenever previous group break hits the page break.
  • Error: (BMT-MD-0003 RQP-DEF-0531 No keys have been specified for….) when validating a determinant in FM Model 10.1.1.
  • RSV-SRV-0040 thrown when viewing any charts in Business Insight after applying the 10.1.4707.1088 hotsite
  • Crosstab aggregation with crosstab spacer causing RMP-ERR-0002( Semantically incorrect request ) against cube
  • list header disappear with suppress rows ON
  • lineage does not worked for saved output when report name contains &
  • Charts showing ampersand as & after HS install if legend turned off
  • Report Studio can’t access TM1 data via FM package
  • OOM issues caused by Firefox Browser
  • Invalid pattern error when switching between crosstab and chart in Analysis Studio
  • System Administrator can not be moved back to Cognos namespace
  • Scheduled reports with expired credentials go to pending state when advanced routing is configured
  • Not able to show any data points or lines if x-axis exceed 2000 entries after upgrading from 10.1 to 10.1 FP1
  • Mapping external data with a report in Report Studio cause java to hang
  • typo in documentation/en/ug_cra_a.html under topic: „Specify the JMX proxy server host“
  • Default for all Steps causes duplicate reports
  • Portlets rendering reports in memory, cause OOM on dispatcher
  • BMT-MD-5002 error updating a view in FM DQM
  • Remove all entries for Excel 2000 from the documentation
  • Active Report as a drill-through target
  • Drill-down option greyed out in an Analysis Studio when one member placed on rows and summary row hidden
  • Customer report with multiple value prompts fails with QE-DEF-0260
  • XQE-GEN-0010 RSV-SRV-0042 ‚The graph is missing nodes.‘
  • XQE-GEN-0002 An unexpeced error has occurred. Cancel handler has not been registered.
  • Render condition adding additional page in 10.1.1
  • Unable to launch Event Studio
  • Can not configure Dynamic Query Mode access to MSSQL named instance
  • Fatal error when searching object depedency in Framework Manager
  • Unable to Connect to TM1 from Cognos Insight
  • Fields on the My Preferences, Personal tab that were editable in 8.4 are not available in C10.1.1
  • invalidCredentials Unexpected exception while executing the xml pipeline process ‚logic‘ when accessing to portal page
  • RQP-DEF-0101 Cross joins error
  • Scatterchart does not exclude 0 on Y-Axis
  • Permissions removed from namespace after content store deployment export
  • Report working in IBM Cognos 8.4 fails when run in IBM Cognos 10.1 or 10.1.1
  • (TR1315) You can’t specify After Rollup for this calculated measure
  • Drillthrough From Active Report not showing Cognos viewer
  • Rounding Negative number results in positive number
  • 10.1.1 BUX: Report widget crashing with CCL-SRV-0513 Out of Memory when locale is Japanese
  • Join Expression is Malformed After Using „Convert to Expression“
  • CM-REQ-4029 when saving a report view after a drill through
  • Inconsistent behavior when changing source report for report view
  • line chart renders without lines in new chart engine (>3000 categories in x-axis)
  • Cognos 10 accepts RSVP.CSV.MIMETYPE value (applicaton/csv) only with typing error
  • Certain non-printing characters in a database cause a java Exception in Portal tab Pages.
  • XQE-GEN-0010 Found an internal error:’The graph is missing nodes.‘ If report is created not using the model’s design language
  • Y2 Axis on combination chart cannot be edited
  • XQE-GEN-0002 and java.lang.ArrayIndexOutOfBoundsException when filter is using dummy expression
  • Cognos for MS Office does not keep parameter values on a refresh
  • Modifying query item in upgraded FM model is slow/lags behind user typing
  • Modern skin change page button hardcoded in Upcoming Activities
  • Negative values are not coming properly in C10RP1 after upgrade from C8.4 FP2
  • Defect: Event Studio agent saves report output although report is not set to save
  • result for Package artifact are not appearing in search results
  • TR1109 String contains a newline character error generated against transformer mdl file
  • Swedish filter on date displays selected value as ‚false‘
  • Annotation Reporting in Cognos 10
  • The aggregate function intersecting a crosstab running-total calculations has returned different results after report upgrade
  • Hour glass never disappears after report is returned in the viewer of Sharepoint 2007
  • Extra chart labels in column chart when viewed in Excel 2010
  • CCLUnknownError when making changes to a model in FM 10.1 Rp1
  • Running-total function works unexpected after upgrade to C10.1.1
  • XQE-GEN-0006 Feature not yet supported: ‚binary‘ when testing query subject in DQM while it is ok in compatible
  • Unable to execute the report with Excel 2007 output
  • Report performance issues with multiple hierarchies in a single dimension (SSAS cube)
  • Receive ppds error while building the incremental cube (TR1901) PDS-PPE-0059
  • Incorrect drill behaviour in Cognos Viewer portlet
  • Grouped DQM report with page sets omits data in Excel format
  • Business Insight shows the tooltips from the first inserted report for all reports when source is saved output
  • CAF Error on Portal Tab – Invalid Variable (ui.action), Invalid Value (authoredDrillThrough2)
  • Maps do not load on 64 bit report server
  • Unable to shift+tab back above the tool bar once you reach Keep this version
  • Bursting shows wrong content per user when containing page set
  • HTTP 500 importing report with nested tables into COC 10.1.1 from BI 10.1.0
  • XQE-PLN-0020 error when using standard-deviation
  • Report causes BIBus to core in ZeroSuppressCellIterator::ProviderGoto(int)
  • DQ: slicer using item function fails
  • A report that properly displayed totals in BI V8.4.1 is displaying the wrong totals
  • RTModels are not created right away in 8.4.1
  • PC Zero Suppression is causing reports to not return in BIA due to not using PPDS zero suppression
  • Mailto hyperlink is failing when exported in PDF format
  • Filter prompting for date values instead of actual column values in Query Studio
  • Dispacher cache causing OutOfMemoryError
  • Missing powerplay cubes when selecting parent folder in migration assistant
  • Cannot save Business Insight dashboard with report „parts“ when using Apache Mod.
  • Business Insight throws The content cannot be displayed The URL address is unavailable, when AppTier is not Internet connected
  • Query studio filter -RQP-DEF-0177 -Cognos 10.1
  • OP-ERR-0172 with prompts in RS report migrated from 8.2 to 10.1.1
  • Results are changed when using custom subset
  • RSV-SRV-0042 Trace back: CGSException. Report not running with certain prompt values
  • SQL Server 2008 datetimeoffset not working in filters
  • UDA gateway unable to action HSTMT CLOSE at EOD when array fetching from DB2 CLI
  • Bullet Chart keep running if no data is available in the end numeric position
  • Aggregate functions work unexpected after upgrade to C10.1.1
  • Shifted cells in Excel when importing a powerplay report
  • Function aggregate is resolved incorrectly after upgrade to 10.1.1
  • XQE-MD-0007 Error When Using Data Source Without Catalogue
  • In BIA when member captions contain apostrophe’s drag and drop stops working
  • Function aggregate with standalone calc is resolved incorrectly after upgrade to 10.1.1
  • CM-REQ-4024 when attempting to overwrite Query Studio file
  • Upgrade instructions from previous IBM Cognos release to Cognos 10.1.1 incorrect
  • Using a block with a fixed size in report gives error CCL_ASSERT(minWidth <= contentWidth) when running with PDF output
  • coring happens frequently
  • BIBusTKServerMain core dumped frequently
  • Manage External Data : wrong values are imported (or replace by zero) during import process
  • crossjoin error after package republish
  • Applying hotfix 1211 causes some Null value issues
  • Not available users appear in sample reports for audit logging
  • Wrong translation for „Release“ button on current activities view in Cognos Administration
  • ppdsweb cores when running a report with nesting multiple rows in AIX
  • Comments in dashboard causes indexing error
  • Sub totals missing after installing Cancel Handler fix (interim fix 10.1.6235.1233)
  • Upgraded reports containing tables nested within tables do not export to Excel 2007
  • Drill through within Business Insight return RSV-SRV-0026 or RSV-SRV- 0040 error
  • IR: CM-REQ-4253 Compressed data in the request is not compressed with a compression compliant with Content Manager
  • Cannot add group to capabilities in Cognos Security when & is used in the search path
Veröffentlicht am

Diagramme Formatieren in IBM Cognos 10 Report Studio

Die Darstellung der Unternehmensdaten in Cognos Reports mit Diagrammen muss sich immer an den Möglichkeiten von Excel  messen. Seit Cognos 8 stehen ja schon viele Diagrammtypen zur Verfügung und in Cognos 10 sind noch mal etliche dazu gekommen. Die Auswahl ist wirklich umfassend, egal ob klassische Balken-, Linien-, Kreisdiagramme oder moderne Tachometer gefragt sind. Jedes Diagramm besitzt eine Reihe Eigenschaften um die Darstellung zuverändern und z.B. mit modernen Farbverläufen und 3D-Schatten zu versehen.

Aber oft sind es die Kleinigkeiten die das Arbeiten mit den Diagrammen verzweifeln lässt. Hier ein Beispiel dazu:

 

Bei komplexeren Anforderungen hilft in den meisten Fällen das Kombinationsdiagramm. Dort ist es möglich mehrere Diagramme in einer Darstellung abzubilden. Aber auch dieses recht einfache Diagramm hat so seine Tücken:

  • die Werte sollen nur bei den letzten beiden Datenpunkten angezeigt werden
  • die Achsbeschriftungen (Umsatz und Anteil %) sollen nicht neben den Achsen stehen, sondern drüber
  • die Stapel-Balken sollen schmal sein
  • …

Die Eigenschaften sind also Schritt für Schritt zu durchforsten. Schwierig ist es hierbei immer das richtige Objekt zu finden – wo stellt man doch gleich die größe der Punkte in der Linie ein? Das gesamte Kombinationsdiagramm hat eine lange Eigenschaftenliste, aber natürlich auch die Unterdiagramme, die Achsen (ach ja, die Primärachse muss einzeln aktiviert werden und der Min – Max Bereich von 100% eingestellt werden), die Beschriftungen… und dann gefunden, die Punkte der Linie sind in der Palette auf zwei Registerkarten definiert.

Was gegenüber bei dieser Anforderung nicht dem Excel-Vergleich stand gehalten hat ist die Formatierung der Werte bei dem Liniendiagramm. Die Farbe der Zahlen sollte eigentlich ebenfalls rot sein und die Werte sollten mehr Abstand zur Linie haben (der erste nach untern, der zweite nach oben). Vielleicht bei der nächsten Vèrsion? Oder doch nur eine Eigenschaft übersehen? …

Wenn man sich erst mal reingefuchst hat, dann machen aber auch die Diagramme im Cognos Report Studio richtig Spaß!