I have a similar issue.I started using a report wa... - SAP Community
source link: https://community.sap.com/t5/technology-q-a/i-have-a-similar-issue-i-started-using-a-report-was-already/qaq-p/13691062
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
yesterday
I started absed on one Crystal report was already created, and I reomved all the associated tables, and created the new ones, and I used I COMMAND, just to have a simple query.
Then, If I run the Report connected to DEV or PROD, it works and very fast, around 1.6 secs.
I have created three Input Paremeters:
1. Plant # ; 2 Initial_Date ; 3. Final_Date.
Running the report locally on my PC, I used Plant # = 02 ; Initial_Date = 04/01/2023 ; Final_Date = 04/30/2023 ( means 1 month ), where I know there are 25 records involved, and it takes 1.6 secs, but If I run from SAP BI, making the Schedule, and running right now, it takes more 40 minutes. What I am missing here ?
I compared this report, and I noticed that as others reports, I have something in the TAB links in Database Expert, but in this one, I don't even have the TAB Links, could be that the issue ?
If so, how can I fix it ?
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK