Search results for query: *

Hi all, Have u ever tried to sort data in cross tab(CT) report? If yes..then u must have broken ur heads.. There is no way u can sort data in CT report.. But ..no worry..with some little manipulation u can do this. Well the soln is using rank..just add one more colum to report with...

Hi I am in an urgent need to display the negative %ge format. When i change the format as %ge the negative values are also shown as positive %ge value. Pls somebody help to show the values as -ve %ge value. Thanx mukesh

Hi all 1. Can we sort data in a cross tab report. I can sort only for fields dragged in rows. 2. What are diffrent uses of hot files. 3. Can i use one report as a input to another report? HOW? 4. Is there a way that a scedular can save a report in excel with formats. 5. What are...

Hi All Pls help 1. Is there any way to save different reports in one excel workbook in different sheets without manually doing the same thing by saving each report in excel then consolidating in one. bye

Hi ganapati Well to create cubes u need transformer. 1. U can create cubes from either the databases that it supports or the iqd file that is a report in impromptu report saved as .iqd file. 2. When u start a new model in transformer u will get five windows: Dimension map, queries, measures and...

well baca u can use prompts for date. One prompt for start date and one prompt for end date. Now u van write scripts which will open the reports and at the same time u can pass the date value as a parameter. this may solve ur problem. bye

Hi Ganpati This is mukesh. Can we be a good friends and share our knowledge. I am working in Philips India Ltd as a DWA and MIS officer. Well the data warehouse is implemented on MS SQL server 7.0 and the reporting tool we use is Impromptu and Powerplay. Pls reply..

Can anybody pls help, its urgent. I want to automate my reports by saving it in excel with formats. But this is possible only with File>Save As. It takes lot of time to do my work. I want to wite cognos script which will save the report in Excel with format. I am using Impromptu Ver. 6 Pls...