Hi,
is there any way to refresh the repository on demmand or the only way to do something like that is to set a small refresh time
Thanks a lot
Hi,
is there any way to refresh the repository on demmand or the only way to do something like that is to set a small refresh time
Thanks a lot
How to force Repository Refresh?
PaoloQuadrani
Thank you for the details. For these cases, you can manually run the adapters and process the cube by invoking the Run webservice by following these steps:
- Log onto the application tier. Browse to http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx
Click on GetWarehouseStatus, and then click the Invoke button. Wait for it to be idle. It should return ProcessingAdapters (pulling data), ProcessingOlap (processing the cube), or Idle.
- Browse to http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx
Click on Run, and then click the Invoke button. This will start the processing of the warehouse. it will return true or false as to whether is started processing (asynchronously).
- You can repeat GetWarehouseStatus to monitor the processing until it returns idle.
Thanks,
Othmane
Raj Nair
I mean makes VSTS refresh de Data Warehouse (and OLAP cubes) on demmand. Sometimes we need to force the processing without waiting for the configured frecuency ("I need the reports updated now!!!" says tha manager and "You can't refresh it every 2 minutes!!" says infraestructure)
Thanks a lot
mtbDad
Hi Lucas,
Could you be more specific on what you mean by repository Do you mean the data warehouse on top of which the cube that is being used by the reports is built If so, then the answer is no, only the refresh frequency is configurable(See http://msdn2.microsoft.com/en-us/library/ms244694(VS.80).aspx).
Also, what do you mean by on demand doing it manually or after every change
Thanks,
Othmane