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 ...
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
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
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) ...
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
Latest Answer : In Decision Stream7 when the data is passed from the source through the data stream we can double click the data stream and click on the option generate SQL, it will show all the total number of records from the input. ...
How do you pass the variable that is entered into a prompt from a Macro of a Hotfile and get the data to show in the final report?
