Can Visual Composer applications be migrated to Design Studios?
With current planning the answer is no as Design Studio is the premium alternative to WAD/Xcelsius and VC is different technology
Does design Studio support Hierarchy?
Yes Design Studio supports all OLAP features that BW provides – time dependent hierarchy, attributes, etc.
What are the differences between Personal, Shared and Secured connections?
A Personal connection is created by one user and cannot be used by other users. The connection details are stored in PDAC.LSI file.
A shared connection can be used by other users through a shared server. The connection details are stored in SDAC.LSI file in the Business Objects installation folder. However one cannot set rights and securities on objects in a shared connection. Neither can a Universe to exported to repository using a shared connection.
A secured connection overcomes these limitations. Through it rights can be set on objects and documents. Universes can be exported to the central repository only through a secured connection. The connection parameters in this case are saved in the CMS.
What is a fan trap? How can it be solved?
In a universe structure, we may have 3 tables joined in such a way that, the 1st table has a one to many join with the 2nd table, which in turn has a one to many join with the 3rd table(A -< B -< C). In such a scenario, if a measure is present in the 2nd table and it is dragged along with any dimension from the 3rd table, the value of the measure will be inflated. Such a condition is known as a fan trap.
A fan trap is solved by creating an alias of the 2nd table and defining contexts such that, the normal table is joined only with the first table, while the alias is joined with both the 1st and the 3rd table. We would take 2nd table’s measure only from the normal table and other dimensions of the 2nd table from the alias table
Should we encounter fan traps in a data warehouse scenario? If so, then how?
If a data warehouse is based on the Kimball model, it is a dimensional schema. In a universe built on that DW, for a fan trap to occur in such a schema, we require direct join between two fact tables, which is against the principles of dimensional modeling.
On the other hand in a data warehouse based on Inmon model, it is a normalized schema. Though in such a case, universes are generally designed on Data Marts, which 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 occur in that universe
What are the 2 different approaches of implementing aggregate awareness? Which one is better in terms of performance?
The 2 approaches are as follows:
Aggregate tables are built in the database, which contains the dimension fields(not foreign keys) along with the aggregated measures. In the universe they are present as standalone tables, i.e they are not joined with any dimensions. Aggregate aware function is used to define both the dimensions and measures of such tables.
No aggregate tables are built in the database level. They contain the normal fact table at different granularities. In the universe, aggregate aware is used only to define the measures and aggregate incompatibility is set accordingly.
The first approach is better in terms of performance, since for the higher levels of aggregation, all the information is obtained for a single table. However, a large scale implementation of this approach in a dimensional schema is difficult. In most BI projects, the second approach is preferred.
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 systems. Plan to connect to other data sources such as universes in the future releases.
When will geo maps/geo coding be added, please?
This is planned for releases after 1.2 in backlog.
Can Design Studio connect to R/3 systems and fetch data from backend tables. If not, are there any alternative tools?
1.2 via SDK via web services; or use transient provider today (ehp 5 ECC 6.0 or higher)
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 not have; with 1.2 will not have geo maps; partner using SDK could do that but beta program has just started.
No comments:
Post a Comment