on 09-11-2014 2:40 PM
Dear Team,
I did not got the concept of few topics?
(1) what is the exactly difference between "ADD" & "Include Link" in Universe parameter? In what situations we use it?
(2)As a developer, How can I check the performance of a query in Webi? I mean query executed time, user executed by, date,time etc?
(3)As a developer, How to justify no of rows coming from Database is equal to no of rows present in Webi?
(4) I am aware about two types of schemas well (i.e) Star schema & SnowFlake Schema. If any other schema is used Plz update me?
Thanks in Advance.
Kittu
Hi
(1) what is the exactly difference between "ADD" & "Include Link" in Universe parameter? In what situations we use it?
(2)As a developer, How can I check the performance of a query in Webi? I mean query executed time, user executed by, date,time etc?
Find the below screenshot.
(3)As a developer, How to justify no of rows coming from Database is equal to no of rows present in Webi?
(4) I am aware about two types of schemas well (i.e) Star schema & SnowFlake Schema. If any other schema is used Plz update me?
Find the below link for more info
Note: PLEASE mark blog as helpful & answered
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sreenivasulu Dasari,
Thanks for your reply.
(1Q) what is the exactly difference between "ADD" & "Include Link" in Universe parameter? In what situations we use it?
Query:These parameters I found in SAP BO3.1 version as well as in SAP BO 4.0 version in UDT (i,e) File > Parameters > Links. I guess there is no equvilaent in IDT. Plz find screen shoot of the same.
(2)As a developer, How can I check the performance of a query in Webi? I mean query executed time, user executed by, date,time etc?
Status: CLEAR
(3)As a developer, How to justify no of rows coming from Database is equal to no of rows present in Webi?
Query:At webi Level I will be knowing no of records, But how to justify that no of records is same in Database? I mean how do we crosscheck with database, Do we use any tool to compare records of webi with DB or any other process?
(4) I am aware about two types of schemas well (i.e) Star schema & SnowFlake Schema. If any other schema is used Plz update me?
Status: CLEAR
Awaiting for your response.
I once again thanks for your support.
Regards,
Kittu
Hi
(3)As a developer, How to justify no of rows coming from Database is equal to no of rows present in Webi?
Query:At webi Level I will be knowing no of records, But how to justify that no of records is same in Database? I mean how do we crosscheck with database, Do we use any tool to compare records of webi with DB or any other process?
There is no tool to compare records of webi with DB or any other process. You need to prepare some test cases. based on back-end DB.
For ex: your webi report displaying EMP Name, EMP No, Manger Name.
DB is SQL. You need to write sample test codes below like
Select EMP Name, EMP No, Manger Name
From EMP table
Where country = IND
Then You need to run the sql code SQL server management studio, and check same results are getting in the webi report are same. Like that you need to prepare test cases and get sign-off from business.
(1Q) what is the exactly difference between "ADD" & "Include Link" in Universe parameter? In what situations we use it?
Query:These parameters I found in SAP BO3.1 version as well as in SAP BO 4.0 version in UDT (i,e) File > Parameters > Links. I guess there is no equvilaent in IDT. Plz find screen shoot of the same.
The Links tab is used with dynamically linked universes, if you want to link the new universe with an existing universe
Add Link: button to select a universe to link with the new universe.
When you set up a link between universes, any change you or other designers make to the core universe are dynamically reflected in the derived universes. You can link only universes that meet the following conditions:
Include
Other than linking universes, you can include the components of the core universe in a derived universe.
When you do this, the universe design tool copies the components of the core universe to the derived universe.
The resulting components in the derived universe are independent of those in the core universe. Therefore, modifying a core universe has no effect on any universes derived from it.
Note: PLEASE mark blog as helpful & answered
User | Count |
---|---|
74 | |
26 | |
10 | |
10 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.