How to force Repository Refresh?

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




Answer this question

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


  • How to force Repository Refresh?