|
| 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 The sub-report only includes the first value."When the sub-report query runs, it checks for the first row in the Customer Name column and shows only information for that customer. If you want a sub-report Latest Answer : By using the 'IN' operator in creation of a prompt we can create a sub report. When the prompt executes, you can select multiple values and the results from the sub-report will reflect those selected items. ... Read Answers (1) | 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 (2) | Asked by : Jagan Use this query i am retriving all years OCt data from 01-10-2004 to 30-10-2007 i need to restrect this query to current date and current year [gosales_goretailers].[Orders].[Order month]between 01 and to_number(to_char(current_date,'MM'))and [gosales_goretailers].[Orders].[Order month]=to_number(to_char(current_date,'MM'))pass polar ID Read Answers (1) | Asked by : ramakrishnamanne Latest Answer : Data source for defining a catalog may be any database.Whether it may be a relational database(like Oracle,sql server, DB2,Tera data etc) ... Read Answers (2) | Asked by : chim Latest Answer : We've 2 ways to import data into a catalog.They are 1. Database which contains all the data 2. Hot file which is meant as local database. this also contains Meta data. ... When You Import data into catalog You have complex columns names. How do you change the Name of those columns? Latest Answer : Steps1. Right-click in the Data Sources list of your model and select Insert Data Source.2. In the New Data Source wizard, enter the name of the data source in the Data Source Name box.3. In the Source Type box, select the type of data source that ... 1.How will u implement drill-thru from powerplay to impromptu?2.How will u highlighting the data other than conditional formatting?3.What is 4-4-5 weeks in powerplay?Why r u using this?4.Why r u using multiple data source?and why cant u use single data source?5.How will u improve the performance of the cube?6.How will u relate the sources in transformer?7.Have u faced any errors while generating the models?8.What is uniqueness error?9.What is the use of Unique property?10.Why there is a property 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
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
