Arul's.TEG Blog

Design Tip #117 Dealing with Data Quality: Don’t Just Sit There, Do Something! Most data quality problems can be traced back to the data capture systems because, historically, they have only been responsible for the level of data quality needed to support transactions. What works for transactions often won’t work for analytics. In fact, many of the attributes we need for analytics are not even necessary for the transactions, and therefore capturing them correctly is just extra work. By requiring better data quality as we move forward, we are requiring the data capture system to meet the needs of both transactions and analytics. Changing the data capture systems to get better data quality is a long term organizational change process. This political journey is often paralyzing for those of us who didn’t expect to be business process engineers in addition to being data warehouse engineers! Do not let this discourage you. You can take some small, productive steps in the short term t

var form = getFormWarpRequest(); var textBox = form._textEditBoxMarketID; var parent=textBox.parentNode; var select; do { parent= parent.parentNode; var select= parent.getElementsByTagName("select"); } while(select.length ==0); var opt = select[0].childNodes; var length=opt.length if (length > 5) // User can select maximum of 5 values from prompt. { alert("You have selected " + length + " O&Ds, Please select only 5 or less "); } In the above code, MarketID is the ID of the TextEditBox Prompt

· Specify passwords to open PDF reports, use PDF options. 1.   Requires a password to open the report 2.   Requires a password to access options §   Allow changes: 1.   Modify the document's content  2.   Add or modify text annotations  3.   Fill in forms and sign the document  4.   Assemble the document (insert, delete or rotate pages and create navigation elements)  §   Allow content extraction: 1.   Extract text for screen reader devices  2.   Copy of text, images, and other content 

Steps: - Open the xls > go to view tab > click Marco > Type Macro name > Click create button > Ms visual basic screen will appear > copy paste below macro and save > close. - Again click on view macro and select the saved macro and run it. - It will rename the tab name w.r.t A1 column - If you don’t want keep the macro in the xls, just delete b’coz people does't like opening any xls with macro Sub Test() For i = 1 To Sheets.Count Worksheets(i).Name = Sheets(i).Range("A1").Value Next End Sub

Add Conditional Rendering   Add conditional rendering to specify which objects are rendered when a report is run. This is useful when your report contains sensitive data. Conditional rendering is not the same as showing or hiding objects . When you hide an object, the object exists but is transparent. If an object is not rendered, it is not in the report. For a list of objects that can be rendered conditionally, see the Render Variable property in "CONREF to ?ti_rptstd_ref_propnew_NOTGENERATED.xml#report_studio_object_and_prop_ref? To open after import, click ->"  . Steps 1.Select the list column to be rendered conditionally. Tip: You must select the list column, not list column body or list column title. If the body or title is selected, as indicated in the Properties pane, use the select ancestor button to select the list column. 2.In the Properties pane, double-click the Render Variable property. 3.Click Variable and click the variable that will be used t

Change Your Home Page You can choose any page in Cognos 8 as your home page. Steps 1. Go to the page you want to set up as your new home page. 2. Next to the home icon , click the arrow, and click Set View as Home

How to combine rows in a list report such that the data within the rows appear on one single row and are comma separated. Business Case Requirement is to display the column data in multiple rows of a list report on a single row comma separated. The list report is grouped on 3 other columns. Resolving the problem Add a crosstab object under a new column of the list report and create a master detail relationship between the list query and crosstab query to achieve the desired reports. e.g Using Go Sales(query) sample IBM Cognos package Steps: 1) Create a list report and drag the following into it: Product Line, Product type, Product name from under the Inventory (query) namespace's, Product query subject. 2) Drag a crosstab object to the list report as the 4th column. 3) Select the first 3 columns in the list report (Product Line, Product Type, Product Name) and group the columns. 4) Go to the Query Explorer and select Query 2. From the Inventory(query) namespace, d

This Document describes how to create a Page Header which only displays on the first page regardless of the output format. Resolving the problem Step by Step instruction: 1. In your report add a new list on top of the page. 2. Add a dummy query item (we will remove it later but need it for the next step). 3. Activate overall list header (Menu -> Structure-> Headers & Footers -> List Headers & Footers -> Overall header). 4. Add your page header information to the list header. 5. On properties pane set rows per page to 2. 6. On properties pane check that pagination property "Repeat every page" is unchecked. 7. You can format the list and table in order to meet you wishes. If you now run the report as pdf the table content will only be shown on the first page

Dimensional Coercion Rules   To simplify building expressions, Cognos 8 provides coercion rules that automatically convert dimensional types. With coercion rules, you can build simpler expressions, making them easier to understand. In addition to the implicit rules that Cognos 8 provides, you can specify these rules explicitly by using various functions. Cognos 8 supports the following types of coercion:   coercion of an object of one dimensional type into another, such as a level into a member set   coercion of a dimensional object into a numeric, date, time, or string value, such as a numeric measure into a numeric value Coercion rules are applied to expressions and data items. In expressions, an operator or function may require operands to be of a particular dimensional type. When an operand is not of the required type, one or more coercion rules may be applied to coerce the operand to the appropriate type. Coercion rules may also be applied to data items to coerce the data