Search results for query: *

Hi Lex Thank you for your reply. It is not that the script is not running in the server at all. It is running fine for some days and giving the error sometimes. Not very consistent. What I have found from the log file produced by the transformer is as follows When running corrcetly it is...

Hi I have created some pyi models and generating the cubes automatically using macros. I have batch file which is calling those macros. If I run the batch files in my m/c it is working fine. When it is running from the production server giving some errors. The erros are not restricted to any...

Do the following. This is not a good solution I believe but solve your purpose for the time being 1. Choose new report 2. Choose Simple List 3. Select Profile from top menu 4. Click the radio 'Sql' 5. Click on Edit and copy the sql written below and paste there 6. Verify it and OK select...

Whether the ownerid in first recordset is the company id of the 2nd?

what the columns of the report?

Ya that will be helpful Thanks Saikat

Are you using a powerplay report. If yes 1.open the report 2.Toggle the dimension viewer (Under Explore menu) 3. From the dimension viewer explore the date dimension you have 4. First check whether you have a category named MTD or not?

Could you tell me what is the query you have used for the first report. For that open the first report. Go to Report --> Query --> Select the Query --> Profile --> Sql --> Edit. If you can copy the sql and send me then I probably I can suggest something Regards Saikat

Select ytd and previous ytd column and then go the calculate --> subtract.

Hi I think both the recordsets are using the data from the same table. Only in this case the last record will be shown in the report otherwise it should show all the records that are matching by company id in the first and second recordset

Hi You can try this 1. Create a blank report using the first dataset (select only the id which you will use in where condition) 2. Now go to the insert --> sub report --> list frame 3. Choose the fields needed (with the id which is needed for where condition) from 2nd recordset 4. Go to the...