|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 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 : Create dataitem by using cast function and use that data item value for the dynamic column name by changing the source value (name under properties) for the column you need. ... Read Answers (9) | Asked by : Jagan 1.diff between drill down and drill through?2. what is meant by roll-up?3.what is meant by external roll-up?how to create external rollup with example?4.what is meant by clean house command?5.what is meant by scope?what are types?explain them6.what is meant by cube groups?how to create cube groups?there is any simplest way to create cube groups?7.what is meant by alternate drill down with ex?8.how many cubes you are created till now?9.what is the size of the present cube?10.why you choose Ex-files What is the size of the cube in ur project?what is the complex report u created in ur project and explain?how dimensions u have in ur project and how many facts?I am new to this dwh. so can anybody give the answers to the above? Administrator wrote on Monday, 21 May 2007 01:48:53:-- test Latest Answer : You can make as many as you can from 1 fact table. Basically IQD's are generated on query subjects. If you have more number of query subjects you can make as many. By the way IQD are used as a source for transformer so we use IQD according to the requirement. ... Read Answers (1) | Asked by : madhubabu bhimaneni How do you handle this DB Schema changes in our Framework manager to update automatically our meta data I have created meta data model using Cognos FM and later source data base column were changed but DBA was not informed the changes. How to handle this DB Schema changes in our Framework manager to update Read Answers (1) | Asked by : Siva What is usage property? Where do we set usage property? What is usage property for fact and dimension tables. What are the properties of usage property? Latest Answer : 1.The Usage Property Identifies the intended usefor the data represented by query item.It determines the aggregation rules of query items and calculations.The different usage property settings areIdentifierFactAttributeUnknown2. To set the usage property ... what is the fact less fact table? why we use this table?give me one example Latest Answer : A fact table without measure is called a fact less fact table for negative analysis report we use this fact less fact table ... what is the repeater tableThanks, Latest Answer : Repeaters are tables in which you can insert items that are repeated when you run the report. For example, use repeaters to create mailing labels. To build a repeater, drop the items you want in the repeater object. Then modify the properties of the repeater ... In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th Latest Answer : School time table show be done in cross tab here the columns should be placed into the cross tabina sequencethe row column should be placed first then the body part and finallythe column should be insertedi think this may help out uRegards,B.SriLakshmi ... Explain with an example for Factless Fact Table in Real Time Project ? Latest Answer : Factless Fact Table: A fact table with a key section but without a measure
section. There are 2 types of factless fact table:
1. Event Tracking Tables: A table that records an event. Ex: A table
that records student attendance. It contains date_key, ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
