Skip to Content
author's profile photo Former Member
Former Member

How QaaWS connection works? Scheduling Webi reports beneficial?

Hi,

Please consider the below scenario,

Data level security is enabled in SSAS OLAP Cube. SSAS server is enabled for Windows AD authentication. So BO side does not require any data restriction.

"Windows AD authentication".is enabled in BO also. Logging in launchpad and all client tools using Windows AD.

We have WebI reports created based on OLAP cubes. Web Services are created and published for the web report. This web service will be consumed by the xcelsius dashboard.

Dashboards are based on QaaWS connection.

Please clarify the following questions:

1. In xcelsius connection - "Refresh before components are loaded". What does this mean?

2. Dashboards are created based on QaaWS connection. So dashboards will show live (current) data or last ran report ?

3. Is it necessary to schedule webi report? How security is applied to the dashboard when it is accessing a scheduled webi instance. (data level security already defined in SSAS OLAP Cube) Widows AD credentials are provided in the user logon window while running the SWF file.

Thanks,

Arun

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 08, 2014 at 11:28 PM

    Hi Arun,

    Check the below reply:

    1. In xcelsius connection - "Refresh before components are loaded". What does this mean?

    This means the connection would be triggered before the swf is loaded. this basically means, when the swf is refreshed it would get the data from the connection first and then display in the components.

    2. Dashboards are created based on QaaWS connection. So dashboards will show live (current) data or last ran report ?

    If you are using QAAWs connection, it would refresh on Demand. But as you mention, it looks you are using "BI web services( block published on Webi). This allows you to choose either to refresh on Demand or get the data from latest instance. To refresh on Demand, set Refresh=True in the input values parameter for the connection(in Data Manager). To refresh on the latest instance, you need to set "getdocumentFrom LatetsInstance" to "TRUE"

    3. Is it necessary to schedule webi report? How security is applied to the dashboard when it is accessing a scheduled webi instance.

    Yes, if you want to refresh from latest instance of report. The security on the Webi would apply.

    Hope this helps.

    Regards,

    Amit

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Amit,

      Thanks for your reply.

      1st point is clear.

      2nd pt - If we are not setting the parameters then I guess the default is considering the last ran webi instance?

      3rd pt - Can you please clarify on the security part.

      In OLAP cube security is set that User1 can see only Region A and User2 can see only Region B.

      WebI report instance will contain all region data right.

      When both user1 and user2 access the dashboard - will they see only their region data?

      Thanks in advance,

      Arun

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.