I want to create a dynamic prompt (i.e. list of values updated when report report refreshed) and I am reading up on this.
I have an option to create a dynamic connection or a normal one. Which one do I create? I will want the prompt to point to different systems when it is moved between systems otherwise want it to connect to one system. I dont want the use to have to select which system they want the prompt to connect to each time.
Will LCM deal with the connections via overrides?
I will be publishing the crystal report to BI 4.0, it will be based on SAP BW/ SQL Server data, the LOV will have to come from SAP BW data (the parameter is created within the Crystal report not the BEx Query).