Index
A
- aggregation
- creating / Getting ready
- working / How it works...
- aggregation property
- about / Aggregation property
- aggregation property, of unit cost
- examining / Getting ready, How to do it...
- aggregation versus pre-aggregated values
- apple style
- about / Pick-up and apply style, How to do it..., How it works...
- applying / Grab them all practice, How to do it..., How it works...
- auto-submit property
- about / Cascaded source, Auto submit
- AV Dashboard / Third-party tools for Cognos
B
- basic concepts, Report Authoring
- detail filter / Summary filter and detail filter
- summary filter / Summary filter and detail filter
- grouped values, sorting / Sorting grouped values
- rollup aggregation property / Aggregation and rollup aggregation
- aggregation property / Aggregation and rollup aggregation
- IF ELSE, implementing in filters / Implementing IF THEN ELSE in filters
- data formatting options / Data formatting options: Dates, numbers, and percentages
- sections, creating / Creating sections
- column, hiding in crosstab / Hiding column in crosstab, How to do it...
- prompts display value / Prompts: Display value versus use value
- boolean variable
- about / Boolean variable
C
- <conditionalStyles> tag / How to do it...
- <crosstabColumns> tag / There's more...
- <crosstabRows> element / How to do it...
- CAFE
- about / CAFE
- CanSubmitPrompt() function
- about / CanSubmitPrompt
- cascaded prompt
- adding / Adding a cascaded prompt, How to do it...
- working / How it works...
- cascaded source property / Cascaded source
- auto-submit property / Auto submit
- CAST function
- about / CAST function
- cells
- merging, in Excel output / Merged cells in Excel output, How to do it..., How it works...
- CheckData() function
- about / CanSubmitPrompt
- classes
- customizing / Customize classes for report-wide effect
- code commenting mechanism
- about / Code comments
- working / How it works...
- Cognos
- third-party tools / Third-party tools for Cognos
- Cognos Go Office
- about / Cognos Go Office
- Cognos Mashup Service
- about / Cognos Mashup Service
- Cognos SQL
- about / How it works...
- colors, for printing reports
- selecting / Choosing right colors, How to do it..., There's more...
- column
- hiding, in crosstab report / Hiding column in crosstab, How to do it..., How it works...
- column titles
- changing conditionally / Conditional column titles, How to do it..., How it works...
- comments
- writing, back to database / Writing back to the database, How to do it...
- conditional block
- about / Conditional block: Many reports in one
- using / Getting ready, How to do it...
- working / How it works...
- conditional drill-through
- defining / Conditional drill-through, How to do it...
- working / How it works...
- conditional formatting
- adding / How to do it...
- working / How it works...
- conditional URLs / How to do it...
- conditional variables
- about / How it works...
- string variable / String variable
- boolean variable / Boolean variable
- report language variable / Report language variable
- copy-pasting
- partial or full report / Copy-pasting partial or full report, How to do it...
- copy report to clipboard option / How it works...
- crosstab reports
- listing / List report or crosstab report, How it works...
- listing, GO Data Warehouse (analysis) package used / Getting ready
- rows or columns, filtering / Filtering rows or columns, How to do it...
- filtering / Filtering whole report
- prompt, adding to Slicer / Adding prompt into slicer and its limitation, How it works...
- zero suppression / New feature for zero suppression
- MUN, for parent-child hierarchy / Level independent MUN for parent child hierarchy
- CSVIdentityNameList function
- about / How it works...
- current_timestamp parameter / How it works...
D
- <drillTargetContext> tag / How to do it...
- data container size
- options, examining / Container size and rows per page
- data formatting defined
- over-riding, in database / Over-riding data formatting defined in database, Getting ready, How to do it...
- data formatting options
- about / Data formatting options: Dates, numbers, and percentages
- date, formatting / Getting data formatting optionsdate, formattingready
- percentages, formatting / % Margin
- data level security
- adding, CSVIdentityMap macro used / Add data level security using CSVIdentityMap macro
- date formatting
- Date Time control
- manipulating / Manipulating Date Time control, How to do it..., How it works..., There's more...
- defaultSelect() function / How it works...
- DESELECT ALL functionality / How it works...
- detail filter
- about / Detail filter
- Dimensionally Modeled Relational (DMR) schemas
- about / CAFE
- dimensions
- swapping, string manipulation used / Swapping dimensions using string manipulation, How to do it...
- DMR (Dimensionally Modeled Relational) sources
- about / Introduction
- drill-through
- creating, from crosstab intersection / Drill-through from crosstab intersection, How to do it..., How it works...
- crosstab intersection, overriding / Overriding crosstab intersection drill-through definition, How it works...
- drill link
- alternating / Alternating drill link, How to do it...
- limitations / How it works...
- Render variable property, using / Render variable
- copy-pasting / Copy-pasting drill link, How to do it..., How it works...
- drill targets
- changing / Quickly changing drill targets, Getting ready, How to do it...
- dropdown box title
E
- environment options, Report Studio
- about / Report Studio environmental options, How to do it...
- view | visual aid / View | Visual Aid
- structure | crosstab node creation option / Structure | Crosstab Node Creation Option
- reuse cognos viewer window / Tools | Options | View | Reuse Cognos Viewer Window
- Excel output
- cells, merging / Merged cells in Excel output, How to do it..., How it works...
- worksheet, naming / Worksheet name in Excel output, How to do it...
- execution time out, Report Studio
- setting / Setting execution time out
- Express Authoring Mode / Express Authoring Mode
F
- <factCell> element / How to do it...
- filtering
- applying / Summary filter and detail filter, How to do it...
- fireevent() function / How it works...
G
- GetElementsByTagName function
- about / GetElementsByTagName
- GO Data Warehouse (analysis) package
- about / Introduction
- Google Map example
- GOSALESDW cube / Getting ready
- GO Sales SSAS Cube package
- about / Introduction
- using / Getting ready
- great_outdoor_warehouse / How to do it...
- green.jpg / How it works...
- grouped values
- sorting / Sorting grouped values, Getting ready
H
- hidden items
- highlighting / Highlighting hidden items, How it works...
- horizontal pagination
- HTML source variable / How to do it...
- Hyperlink component
I
- iFrame-Products / Getting ready
- iFrame-Retailers / Getting ready
- IF THEN ELSE
- implementing, in filters / Implementing IF THEN ELSE in filters, How to do it...
- image component / How it works...
- image object / How to do it...
- images
- displaying dynamically / Showing images dynamically (Traffic Light report), Getting ready
- relative path / Relative path for images, How to do it...
- displaying / Relative path for images, How to do it...
- relative path, working / How it works...
- img2txt / How it works...
J
- Javascripting
- about / Introduction
- JavaScripts
- about / Introduction
- taming / Taming the JavaScripts, How to do it...
- working / How it works...
K
- keep with header property / There's more...
L
- <listItem> tags / How to do it...
- listbox
- creating / Listbox: Applying Deselect All on rerun , How to do it...
M
- macros
- about / Introduction
- master detail relationship
- defining / Master Detail relationship
- maximum execution time property / How it works...
- maximum rows limit, Report Studio
- setting / Setting maximum rows limit, How to do it...
- Microchart
- about / See also
- Running difference / Running difference
- data format options / Showing negative values in red and brackets
- Microsoft SQL Server Analysis Services (SSAS)
- about / Introduction
- minimum column width
- achieving / Achieving minimum column width, How to do it...
- missing image issue
- missing value
- versus, zero value / Missing value versus zero value
- missing value characters
- setting / Getting ready, How to do it..., How it works...
- MNU, for parent-child hierarchy
- about / Level independent MUN for parent child hierarchy
- making, level independent / Level independent MUN for parent child hierarchy, How to do it...
- working / How it works...
- Motio
- about / Third-party tools for Cognos
- MotioADF
- about / Third-party tools for Cognos
- multiple aggregations
- about / Multiple aggregations
- multiple report views
- creating / There's more...
- MUN
- manipulating, macros used / How it works...
N
- Native SQL
- about / How it works...
- negative values
- showing, in red and brackets / Running difference: Negative values in brackets and red, How to do it..., Showing negative values in red and brackets
- nested report
- new conditional styles property
- about / New conditional styling with v8.3 onwards
- using / Getting ready, How to do it...
- working / How it works...
O
- onError event / How it works...
- open report from clipboard option / How it works...
- Optional_defaultValue / Optional_defaultValue
- OrderMethod variable / How to do it...
- orphan rows
- eliminating / Eliminating orphan rows
- output format
- selecting, from prompt / Choosing output format from prompt, How it works...
P
- page orientation and size
- page set
- defining / Defining page set, How it works...
- page structure view
- about / Page structure view, How it works...
- page title repetition
- pagination property / How to do it...
- ParamDisplayValue / There's more...
- ParamValue / There's more...
- partial or full report
- copy-pasting / Copy-pasting partial or full report, How to do it..., How it works...
- PDF page setup property / How to do it...
- pick-up style
- about / Pick-up and apply style, How to do it..., How it works...
- applying / Grab them all practice, How to do it..., How it works...
- PimpMyReport
- about / Third-party tools for Cognos
- printable reports
- writing / Introduction
- size & overflow property / How to do it...
- running, in HTML and PDF formats / How to do it...
- working / How it works...
- orphan rows, eliminating / Eliminating orphan rows, There's more...
- page orientation and size, defining / Defining page orientation and size (also override for one page), How to do it..., How it works...
- page title repetition, avoiding / Avoiding page title repetition, Getting ready, How to do it..., How it works...
- horizontal pagination / Horizontal pagination, How to do it..., How it works...
- output format, selecting from prompt / Choosing output format from prompt, How it works...
- colors, selecting / Choosing right colors, How to do it..., There's more...
- page set, defining / Defining page set, How it works...
- caution, about HTML items and JavaScript / Caution about HTML items and JavaScript
- prompt
- making optional / Making prompt optional, How to do it...
- Prompt() function / There's more...
- promptButtonFinish() function / How it works..., How it works...
- prompt controls
- showing/hiding, at runtime / Show/Hide prompt controls at runtime, How to do it..., How it works...
- prompt macro
- using in query object / Using prompt and promptmany macros in query subject
- prompt macro, using in native SQL
- about / Using prompt macro in native SQL, How to do it...
- working / How it works...
- PromptMany() macro function / There's more...
- promptmany macro
- using in query object / Using prompt and promptmany macros in query subject
- prompts
- display value / Prompts: Display value versus use value , How to dopromptsdisplay value it..., How it works...
- dynamic default value / Dynamic default value for prompt
- prompt types
- recommendations / Recommendation for prompt types
- prompt values
- submitting, automatically / Automatic selection and submission of values, How to do it..., How it works...
- selecting, automatically / Automatic selection and submission of values, How to do it..., How it works...
- displaying, in report / Showing the prompt values in report based on security
- Pure_Optional / Pure_Optional
Q
- query
- capturing / Capturing query, How to do it...
- formatting / Query formatting
- capturing, for database / Capture the query for database
- query items
- reducing / Reducing number of query items, Getting ready, How to do it...
- reducing, alias member unique name option used / Alias member unique name
- reducing, delete unreferenced query objects option used / Delete unreferenced query objects
- reducing, dragging items from data items pane option used / Dragging items from data items pane
R
- <report> tag / How to do it...
- <reportDrill> element / How to do it...
- <reportDrills> tag / There's more...
- references
- regression testing
- about / Regression testing, How to do it...
- working / How it works...
- REMOVE() function / There's more...
- Render Variable property / How to do it...
- Render_Comments variable / How to do it...
- report
- copy-pasting, from 8.2 to 8.4 / Copy-pasting whole reports—8.2 to 8.4 possible, How it works...
- report execution time
- recording / Timing report execution, How to do it...
- report language variable
- about / Report language variable
- report options
- alias member unique names / Tools | Options | Report Options
- delete unreferenced query objects / Tools | Options | Report Options
- delete unreferenced conditional styles / Tools | Options | Report Options
- aggregation mode / Tools | Options | Report Options
- reports
- switching, iFrame used / Dynamically switching reports using iFrame, How to do it..., How it works...
- Report Studio
- filtering / Summary filter and detail filter
- prompt display value / Prompts: Display value versus use value
- cascaded source property / Cascaded source
- Microchart / See also
- conditional styles property / New conditional styling with v8.3 onwards
- conditional block / Conditional block: Many reports in one
- about / Introduction
- JavaScripts / Introduction
- images, displaying / Showing images dynamically (Traffic Light report)
- missing image issue, handling / Handling missing image issue
- Hyperlink component / Dynamic links to external website (Google Map example)
- Google Map example / Dynamic links to external website (Google Map example)
- drill link, alternating / Alternating drill link
- tool tip, showing in reports / Showing tool tip on reports
- minimum column width, achieving / Achieving minimum column width
- cells, merging in Excel output / Merged cells in Excel output
- worksheet, naming in Excel output / Worksheet name in Excel output
- column titles, changing / Conditional column titles
- drill targets, changing / How it works...
- environment options / Report Studio environmental options, How to do it...
- execution time out, setting / Setting execution time out
- maximum execution time property / How it works...
- maximum rows limit, setting / Setting maximum rows limit, How to do it...
- slow report validation, handling / Handle slow report validation, Getting ready, There's more...
- query, capturing / Capturing query, How to do it...
- values, browsing from data expression window / Browsing values from data expression window
- page structure view / Page structure view, How it works...
- apple style / Pick-up and apply style, How to do it..., How it works...
- pick-up style / Pick-up and apply style, How to do it..., How it works...
- pick-up style, applying / Grab them all practice
- apple style, applying / Grab them all practice
- query items, reducing / Reducing number of query items, Getting ready, How to do it...
- hidden items, highlighting / Highlighting hidden items, How it works...
- relative path, for images / Relative path for images, How to do it...
- JavaScripts, taming / Taming the JavaScripts, How to do it...
- standard formatting, applying / Customize classes for report-wide effect, How to do it...
- templates, creating / Creating templates, How to do it...
- regression testing / Regression testing, How to do it...
- code commenting mechanism / Code comments, How to do it...
- version controlling / Version controlling
- prompt types / Recommendation for prompt types
- Express Authoring Mode / Express Authoring Mode
- Report Studio filters
- about / How it works...
- working / How it works...
- report view
- creating / Report view
- roleValue() function
- about / RoleValue() function, How to do it...
- working / How it works...
- rollup aggregation
- about / Rollup aggregation
- row level formatting
- defining / A hidden gem in XML—row level formatting, How to do it...
- working / How it works...
- rows or columns
- filtering / Filtering rows or columns, How to do it...
- rows per page
- options, examining / Container size and rows per page
- Running difference function
S
- <span> tag / How it works...
- schedule management view
- about / Scheduling
- sections
- creating / Creating sections, How to do it..., How it works...
- SELECT ALL functionality / How it works...
- SelectedIndex property
- about / SelectedIndex
- size and overflow properties
- height / How to do it...
- width / How to do it...
- about / There's more...
- Slicer
- about / How it works...
- prompt, adding / Adding prompt into slicer and its limitation
- limitations / More Info
- slow report validation
- handling / Handle slow report validation, Getting ready, There's more...
- sort option
- about / How it works...
- SPAN
- about / SPAN
- SpecStudio
- about / Third-party tools for Cognos
- standard formatting
- applying, to report / Customize classes for report-wide effect, How to do it..., How it works...
- string operations
- about / String operations to get it right
- working / How it works...
- string variable
- about / String variable
- style.display property / There's more...
- style variable property
- about / Style variable property
- summary filter
- about / Summary filter
T
- template attribute / How to do it...
- templates
- creating / Creating templates, How to do it...
- textbox prompts
- validating / Validating textbox prompts, How it works...
- text source variable property
- about / Text source variable property
- Text source variable property
- about / Conditional column titles
- third-party tools
- AV Dashboard / Third-party tools for Cognos
- about / Third-party tools for Cognos
- Xcelsius / Third-party tools for Cognos
- PimpMyReport / Third-party tools for Cognos
- SpecStudio / Third-party tools for Cognos
- Motio / Third-party tools for Cognos
- timestampMask() function / How it works...
- token
- adding, macro used / Adding token using macro, How to do it...
- tool tip
- displaying, in reports / Showing tool tip on reports, How to do it...
- traffic variable / How it works...
U
- user name
- showing, in footer / Showing user name in footer, Getting ready, How it works...
V
- ValidatePage() function / How it works...
- value prompt
- selecting / How to do it...
- values
- browsing, from data expression window / Browsing values from data expression window, How to do it...
- variable width bar chart
- creating, JavaScript used / Variable width bar chart using JavaScript, How to do it...
- working / How it works...
- vaules, report
- filtering / Filtering whole report
- filtering, Slicer used / How it works...
- version controlling
- about / Version controlling
- methods / Version controlling
W
- worksheet
- naming, Excel output / Worksheet name in Excel output, How to do it...
X
- Xcelsius / Third-party tools for Cognos
- XML
- references / Introduction
- row level formatting / A hidden gem in XML—row level formatting, How to do it...
- XML editing
- about / Introduction
- XML editor
- advantages / Introduction
- about / Introduction
- xmlns attribute / How to do it...
Z
- zero suppression
- about / New feature for zero suppression
- working / How it works...