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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.