Interview Questions.

Q1. Do You Have Rri (document To Report Interface) Functionality In Design Studio ?

If asking about defined BW – do not have – planned for 1.3 launch. If bounce from one app to every other, can use opendoc hyperlink nowadays  .

Q2. What Are The Different Ways In Which An Xcelcius Dashboard Can Access Data From A Bo Universe?

There are 3 methods wherein Xcelcius can access records from the universe:

Query as a Web Service: Using Query as a Web Service device, we can create a queries from the universe along side clear out circumstance. The QAAWS qury panel is similar to the WebIntelligence question panel. In Xcelcius dashboard, we will create a QAAWS connection that might factor to a specific Query and import the records into the excel statistics sheet of the xlf

Business Intelligence Web Service: In this method, we can use the output of a file without delay within the Xcelcius dashboard. Using Webi Rich Client, we export the record to repository, then pick out a block from the report, right click and select Publish as Web Service choice. However BIWS does no longer have a connection of its very own. We get right of entry to this BIWS via a QAAWS connection handiest.

LiveOffice: LiveOffice is a further component that desires to be installed. This creates a kind of plugin for all MS Office packages, though which they are able to get entry to records from Web Intelligence reports. I MS Excel, we will release the Live Office Insert Wizard via Insert -> Web Intelligence Content. We can use this wizard to feature selective content from a webi record. In the Xcelcius dashboard, a Live Office connection is created andwe get admission to this Live Office excel sheet although this connection.

Q3. Is This Only For Bw And Olap? If Yes, Is There A Plan To Use It With Other Data Sources?

Design Studio 1.1  can connect to BW and HANA as backend structures.  Plan to connect to other facts assets consisting of universes in the future releases. 

Q4. Is There A Data Size Limit Using Design Studio?

Cannot normally say restrict for that – no longer like Xcelsius trouble.  DS uses BICS interface to connect to BW / HANA (analytic/calc perspectives).

Q5. How Can Geo-maps Be Integrated In Design Studio? Are There Any 3rd Party Add-ons Which Design Studio Support For The Same ?

With 1.1 do no longer have; with 1.2 will now not have geo maps; partner using SDK could do this but beta software has just started. 

Q6. What Is The Use Of The Scope Of Analysis Pane In The Query Tab Of Webi Report?

It has 2 uses:

The Scope of Analysis pane sets the restriction of drill down in the document. Suppose we have a hierarchy defined in 3 tiers, but if we set the scope of evaluation is set to two ranges, the file will not be capable of drill down to the 3rd stage. We also can dispose of gadgets showing within the scope of evaluation pane and restrict the drill down.

If the evaluation level is ready to custom, the gadgets from current hierarchies can be dragged in the scope of evaluation panel to set the scope for drilldown inside the file. This has an advantage that we can drill down to extra than three stages, which is not viable within the ordinary stage setting, since it's far up to a few best.

Q7. What Are The 2 Different Approaches Of Implementing Aggregate Awareness? Which One Is Better In Terms Of Performance?

The 2 processes are as follows:

Aggregate tables are constructed within the database, which contains the dimension fields(no longer foreign keys) together with the aggregated measures. In the universe they're gift as standalone tables, i.E they're no longer joined with any dimensions. Aggregate conscious characteristic is used to outline both the dimensions and measures of such tables.

No aggregate tables are constructed inside the database degree. They contain the normal truth table at special granularities. In the universe, combination conscious is used handiest to define the measures and combination incompatibility is about for that reason.

The first approach is better in terms of overall performance, on the grounds that for the better levels of aggregation, all of the statistics is acquired for a unmarried desk. However, a massive scale implementation of this method in a dimensional schema is hard. In most BI projects, the second approach is favored.

Q8. Which Xcelsius Components Can We Use For Linking Multiple Dashboard Flash Outputs(swf Files)? Can The Same Components Be Used For A Complete Presentation?

We can use ‘Swf Loader’ as well as ‘Slideshow’ additives for linking more than one dashboards. ‘Swf Loader’ can open swf documents most effective, while ‘Slideshow’ can open both swf documents and photo files.

For presentation purposes, we frequently want textual content and photographs. Hence these are embedded in photo files are added to a ‘Slideshow’ along side dashboard outputs. Moreover ‘Swf Loader’ can simplest open swf thru ‘Push Button’ or selector additives, while ‘Slideshow’ has a function of computerized slide transition, which hundreds the photograph and swf files within the certain series. Hence, ‘Slideshow’ is the best possible choice for a complete presentation.

Q9. What Are The Differences Between Personal, Shared And Secured Connections?

A Personal connection is created by one user and can't be utilized by different customers. The connection info are saved in PDAC.LSI report.

A shared connection may be utilized by other customers via a shared server. The connection info are saved in SDAC.LSI report in the Business Objects set up folder. However one can not set rights and securities on gadgets in a shared connection. Neither can a Universe to exported to repository the use of a shared connection.

A secured connection overcomes those limitations. Through it rights may be set on gadgets and files. Universes can be exported to the valuable repository simplest via a secured connection. The connection parameters in this case are saved within the CMS.

Q10. Should We Encounter Fan Traps In A Data Warehouse Scenario? If So, Then How?

If a data warehouse is primarily based at the Kimball version, it is a dimensional schema. In a universe constructed on that DW, for a fan entice to arise in such a schema, we require direct be a part of between two reality tables, which is towards the concepts of dimensional modeling.

On the opposite hand in a facts warehouse based on Inmon version, it's miles a normalized schema. Though in any such case, universes are typically designed on Data Marts, that are dimensional schemas (where fan traps should not occur). However, if a universe is built on the DW (for the purpose of operational reporting), then a fan trap can arise in that universe.

Q11. How Can We Use Index Awareness In Universe Prompt?

An extended prompt syntax is to be had given that BO 3.@It is as follows

@Prompt( ’message’, ‘kind’, [lov],

mono/multi,

unfastened/limited/primary_key,

chronic/not_persistent,

‘default value’:’default key’ )

If the indexes for the dimension item is described in the universe and we define the prompt condition on the item with the clause ‘number one key’ in place of free or constrained, then the filter circumstance will convert the prompt values entered to their corresponding indexes and take away the join with the measurement table

Q12. What Is A Condition Object? How Is It Different From Query Filter?

A condition item is a filter out condition created in the universe stage. When this item is dragged within the Query Panel, the filter out circumstance seems within the query SQL.

However a question clear out exists inside the record simplest. It is delivered at some point of building a query. This additionally seems in the question SQL.

Q13. For Hana Data, The Analysis View Is The Source For Design Studio? How About Other Views?

Calc perspectives can be a information supply too .

Q14. Does Design Studio Support Hierarchy?

Yes Design Studio helps all OLAP features that BW affords – time structured hierarchy, attributes, and so on.

Q15. What The Technology Design Studio Use , Which Is Different With Dashboard?

DS is HTML5 based and Dashboard has furnished HTML5 model responded earlier than, turns into one tool in long-time.  DS is optimized for BW and HANA and could provide guide for  universes. 

Q16. Do We Have Bookmark Concepts In Design Studio In Future ?

Yes this is planned for  the destiny as Design Studio is a successor to WAD.

Q17. We Are Planning Upgrading Ds 1.1 With Sp02, We Noticed That It Will Only Work With Internet Explorer 10?

Works with IE9 – test the PAM or possibly installed a assist ticket.

Q18. How Can We Access One Derived Table From Another?

We can access one derived desk from every other using the function @derived_table.

The syntax is:

@derived_table(Derived Table Name)

Q19. When Should We Use A Query Filter And When A Report Filter?

The choice of query or record filter out has to soak up consideration the performance of the report.

Suppose we've got record wherein are multiple tabs having unique items requiring same or different filter conditions, it's far beneficial to apply a Query Filter.

In case where there are multiple tabs having identical gadgets, however with barely differing filter conditions, it's miles beneficial to fetch the entire statistics in the question after which apply record filters to the diverse tabs to get the preferred data in place of the usage of separate queries for each tab.

Q20. In Oracle, We Use Instr Function To Display The Position Of A Character In A String. What Is The Corresponding Bo Web Intelligence Report Function, That Does The Same?

The corresponding feature is Pos().

The syntax is:

Pos( string input_string; string sample )

Q21. How Can We Make Design Studio Dashboards Available On Mobile?

2 alternatives – 1 for cease customers use the Mobile BI solution the usage of the Bi platform, class cell to DS utility then see it on the MobI app. Developers can do it locally the use of QR codes.

Q22. Is Design Studio Using Html 5 For Ipad? Same With Iphone?

Yes, precisely; era is HTML5 and might installation on mobile devices.  Deploy on iPhone, iPad, or Mobile BI answer .

Q23. What Happens When We Click The Include Button After Linking Two Universes?

After developing a link if the ‘Include’ button is clicked then the tables from middle universe are completely copied into the derived universe and the link is severed.

Q24. Which Selector Gives The Option Of Multiple Selection In Xcelcius Dashboard? How Do We Make The Multiple Selections?

Only ‘List Builder’ offers the option of more than one selection in Xcelcius. We pick out more than one rows from the enter list and add them to the output list using Add button. The output listing gives the selection parameter.

Q25. How Is A Derived Table Different From A View? Which One Is A Preferred Solution?

A derived table is gift handiest within the universe stage, even as a view is created in statistics base degree. Generally perspectives are desired seeing that, in its case the onus of calculation stays at the database and it does no longer load the BO server. However, in cases where builders do now not have get admission to to database, derived table is the only answer.

Q26. Will It Work With Other Browsers: Firefox, Chrome, Etc?

Yes will paintings with different browsers.

Q27. What Is The Difference Between Input And Output Calculation Contexts In A Webi Report?

Input context includes any dimension items that want to be included at once within the calculation itself.

Output context includes one or more dimension gadgets that determine the aggregation level at which the calculation is displayed.

Q28. Can Visual Composer Applications Be Migrated To Design Studios?

No, as Design Studio is the premium opportunity to WAD/Xcelsius and VC is one-of-a-kind era .

Q29. What Is A Fan Trap? How Can It Be Solved?

In a universe structure, we may have 3 tables joined in any such manner that, the 1st table has a one to many be part of with the 2d desk, which in turn has a one to many be part of with the 3rd desk(A -< B -< C). In any such scenario, if a measure is gift inside the second desk and it's far dragged in conjunction with any measurement from the third table, the cost of the degree could be inflated. Such a circumstance is known as a fan entice.

A fan trap is solved with the aid of creating an alias of the 2nd desk and defining contexts such that, the everyday desk is joined most effective with the first desk, even as the alias is joined with each the first and the third desk. We could take second table’s degree best from the normal desk and other dimensions of the second table from the alias desk.

Q30. Suppose We Want To Display The Total Sum Of A Measure In Row Level Of The Report Block. What Will Be The Solution?

We should use context Operator In together with key-word file. This will give the full sum of the degree in row degree(and anywhere inside the document).

The expression can be like:

Sum( Measure In Report )

Q31. What Are The Added Features Of Interactive Mode In Web Intelligence Over The Normal Java Report Panel? What Are Its Uses?

When Web Intelligence is in Interactive mode, one can create variables, input controls, add file filters, tables and charts in the view mode itself. This is not viable within the everyday Java document panel.

The gain of interactive mode is for electricity customers, who want to do similarly manipulations on an existing file. Since, it does no longer permit user to modify queries or existing variables inside the document, but allows doing the above stated activities on top of the record, it gives a excellent manner for evaluation through the strength users without changing the core record in any manner.