Universe mapping in data foundation

[former_member211289]

Hi All,

I'm using existing universe .UNV for enhancement project.

My Query is as follows :-

During universe mapping,I was imported few more tables in to existing universe and joined with relation.

and I was completed universe mapping with few tables left with out join.

Now If I write a query do I face data related issues as I left few tables with out join?

Please give your reply in a detail manner.

Thanks

Ram

[amitrathi239 · Accepted solution]

Ideally your all tables should be joined.But again it based on the universe development  & standalone tables need.Some time standalone table used in the Data foundation for custom LOV purpose.But objects are not created from these standalone tables in business layer.

Untill you will drag the object from standalone Class->Table in the webi query with some other joined tables objects you will not get the issue.

Issue will come when you drag objects from standalone table & joined table in single webi query.

[former_member211289 · Accepted solution]

Hi Amit,

As per the below one ,you mentioned that

But objects are not created from these standalone tables in business layer.

and you also mentioned that ,Until you will drag the object from standalone Class

Can't we convert columns in to objects from standalone tables in business layer ?

[amitrathi239 · Accepted solution]

There are couple of scenario of Standalone tables.

1)Standalone Table in Data Foundation:If standalone table is only in the DF layer and objects are not created  on top of these tables in the Business layer then no issue.

2)Standalone table in DF and Objects in Business layer:If you have created objects in the Business layer on top of Standalone tables then you have to be very sure when you have to use the objects from these tables in the webi query.

Scenario 2 will work if audience is limited for universe use.It mean developer know when they have to use objects from standalone tables.

If you drag objects from standalone table with joined tables objects in the webi query then you will get the error message or wrong result.

[former_member211289 · Accepted solution]

Hi Amit,

You have provided good information for me.

One clarification Amit,

If we use Aggregate tables in place of standalone tables,please mention your comment .

Basically Aggregate tables far away from schema right ,so can we consider Aggregate tables as

standalone tables.

[former_member211289 · Accepted solution]

Amit,

Please elaborate the below comment :-

Scenario 2 will work if audience is limited for universe use.It mean developer know when they have to use

objects from standalone tables.

[amitrathi239 · Accepted solution]

Some time if small group is only going to use the universe for reports development & Ah doc reporting then you trained them when you have to use the standalone tables.But if wider audience is going to use the universe for reporting  then it's difficult to explain everyone on standalone tables when they have to use.

That is the reason it's not good to keep the standalone  tables/objects in the universe.

If your database design is proper then you will not get the standalone tables in database & universe.

[former_member211289 · Accepted solution]

Amit,

Basically Aggregate tables far away from schema right ,so shall we consider Aggregate tables as

standalone tables ?

[amitrathi239 · Accepted solution]

Your aggregate tables means club all master and transactional data in single table or transactional data grouping  only?

If your database design is in proper way then no need  to go with standalone tables. Aggregated tables are good for performance if you have aggregated data for different view like Monthly/yearly aggregated data.But again you need to join these with  master data.

How many users are going to use your universe?

Any Adhoc reporting requirement on this universe?

What is the reason standalone tables in your database?

[former_member211289 · Accepted solution]

Amit,

1.How many users are going to use your universe?

Only one user that too I'm using existing universe for enhancement project.

2.Any Adhoc reporting requirement on this universe?

By using Web I tool ,I need to create three reports.

3.What is the reason standalone tables in your database?

As I mentioned previously ,I'm using existing universe for enhancement project.

That universe contains two standalone tables.

Universe mapping in data foundation

[amitrathi239 · Accepted solution]

Your are the only who is developing report but might be the case users are using this universe  for Adhoc reporting which you don't know.I would suggest first check who is going to use this universe for reporting and before adding the standalone tables discuss with respective team if they have some issue.

If not then you can go head and can add the tables as standalone.It's better always in these cases take the confirmation from respective owners for ding these changes.