 Related Questions 1.Create a calculated column which contains the information that the header is to contain, such as "Report for year 1999" (concatenated text and date to string sub string extraction). 2.Highlight Latest Answer : You can use the following steps to have a dynamic column title1. Click the unlock button and unlock the report design2. Delete the column title3. Place a text item on the column4. Go to the query explorer5. Drag a data item into the query6. write the ... Read Answers (11) | Asked by : Jagan How to show the data reported horizontally:(For example:)employee skill1 a1 b1 c2 d2 e2 fReport result:1 abc2 def Assuming 3 records per grouped item:1. Group on employee2. Create a running count based on the skill field.3. Create 3 calculated columns based on the count field.Call them skill1, skill2, skill3:if (count Read Answers (3) | Asked by : Jagan What is meant by Junk Dimension?How do you perfom while running the report?Where will you see the time of running report?Size of the cube?What are the types of prompts in ReportNet?What is macro and how it will be work?What is difference between Cognos and Cognos ReportNet?How do you create cube in ReportNet?There are 10 facts are there.How will you connect all? I need answer Read Answers (11) | Asked by : hakkim Latest Answer : Can you explain in breif means to say that the exact way how to drill down to each cube ... Read Answers (2) | Asked by : suresh babu View Question | Asked by : SC Latest Answer : Catalog contains metadata which is used retrieved by warehouse database is called catalog.Actually 4 types
catalogs. They arePersonal catalogShared catalogSecured catalogMaster Distributed catalog.MDC is better one ... Read Answers (8) | Asked by : chimpara reddy Latest Answer : 1. In Cognos Connection, Go to Public Folders or My Folders, click the schedule button for the report you want to schedule.2. Under frequency, select how often you want the schedule to run.3. Under Start, select the date and time you want the schedule ... Read Answers (4) | Asked by : chim Latest Answer : Users and Permissions can be given in Access manager - Administration. Individual users can be created using their names or their Ids (if any) in Access manager and then be given permissions. This tool is loaded when you install Cognos 7.x in your machine. ... Read Answers (4) | Asked by : chim Latest Answer : Hi,You can change database connections in Catalog level.Catalog-->Tables-->retrieve table.You will see radio button for Atached dB. use the list box and select a desirable DB if it is attached to Cognos. or else create DB connecting by selecting ... Read Answers (1) | Asked by : chim Latest Answer : Model is a way to represent the architechtural structure of the Data warehouse. It consists of dimensions, Data sources, Measures. To create a model following steps should be followed 1. From the File menu, click New 2. Enter the name of the model3. ... Read Answers (2) | Asked by : chim
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
