BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Universe and Data Access enhancements
1 members found this topic helpful
Goto page 1, 2, 3, 4  Next
 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
dnewton
Forum Addict
Forum Addict



Joined: 30 Jan 2004
ASUG Icon
Posts: 3458
Location: Massachusetts, USA


flag
PostPosted: Thu Dec 11, 2008 3:16 pm 
Post subject: Universe and Data Access enhancements

Let's start a sticky thread to keep track of suggestions and ideas related to the Semantic Layer (the Universes) as well as Data access from those universes.

Please post replies with your ideas...
Back to top
dnewton
Forum Addict
Forum Addict



Joined: 30 Jan 2004
ASUG Icon
Posts: 3458
Location: Massachusetts, USA


flag
PostPosted: Thu Dec 11, 2008 3:19 pm 
Post subject: Re: Universe and Data Access enhancements

Idea: Better database metadata reuse and support within Designer.

Database tables and columns can have long descriptions or COMMENTs on them in SQL Server, Oracle, and presumably other tables. It would be nice to see this data within the Universe layer. When you drag in a table, you could get not just the list of columns and datatypes, but the metadata too.

Furthermore, when you then drag a table or column over to the left-hand pane to add it to your universe, the object metadata (business terms etc.) should default into the object descriptions.
Back to top
dnewton
Forum Addict
Forum Addict



Joined: 30 Jan 2004
ASUG Icon
Posts: 3458
Location: Massachusetts, USA


flag
PostPosted: Thu Dec 11, 2008 3:21 pm 
Post subject: Re: Universe and Data Access enhancements

Idea: Reusable queries. (This is a grey area between report design and Universe design) I'd like to create a query with complex filtering (WHERE clause) logic, and then reuse that query across 3 separate reports. If I change the single query, all downstream reports would be affected.

This could be hacked by using QaaWS, but I'd like to see it a standalone thing, a sort of "Query Publisher" and then a webi data provider could simply point at a Query and not just a Universe.
Back to top
dnewton
Forum Addict
Forum Addict



Joined: 30 Jan 2004
ASUG Icon
Posts: 3458
Location: Massachusetts, USA


flag
PostPosted: Thu Dec 11, 2008 3:24 pm 
Post subject: Re: Universe and Data Access enhancements

Idea: Make Universe Designer a more object-oriented approach or application.

For example, you might have a field in a table CUSTOMER_DIM.CUSTOMER_NAME. If you could define that column once (pretty name, long description, LOV, etc.), and then reuse and inherit that in all universes, it would make maintenance easier. We have dozens of standard objects that exist in dozens of universes. If we change the description of the object in one place, we have to spend time doing it many other places.

You can do embedded/linked universes, but these are at too high of a grain.

You'd also want your inherited attributes to stick when you aliased a table. Plus have the ability to override that inheritance.
Back to top
ajunell
Principal Member
Principal Member



Joined: 03 May 2004

Posts: 230
Location: Amarillo, TX


flag
PostPosted: Thu Dec 11, 2008 3:58 pm 
Post subject: Re: Universe and Data Access enhancements

Allow object and class names to come from a db column or a stored procedure. This would allow them to be dynamic and potentially changed by the end user without having to load up Designer and import/export.

For example, one client might want to call an object 'Employee', but another client might prefer the term 'Colleague'.

_________________
Alan Junell BOCP-BOE
Back to top
dnewton
Forum Addict
Forum Addict



Joined: 30 Jan 2004
ASUG Icon
Posts: 3458
Location: Massachusetts, USA


flag
PostPosted: Thu Dec 11, 2008 10:14 pm 
Post subject: Re: Universe and Data Access enhancements

Provide a way to let the Universe layer talk to more than one database/data source. I think this really means baking the Data Federator product into the Universe layer.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19320
Location: Bratislava


flag
PostPosted: Fri Dec 12, 2008 3:00 pm 
Post subject: Re: Universe and Data Access enhancements

Idea: possibility to reuse once-defined keys for index awareness.

Scenario: I have a dimension table (DT) and a fact table (FT). They are joined via primary key and foreign key. There are many objects defined based on DT.

If I want to set up an index awareness, I need to define keys (primary and foreign) for each of the objects individually. I need to go to Keys tab of properties of each and every object and add keys manually again and again for each object individually.

I would like to have a possibility to define keys between 2 tables once and then to reuse this information for all objects where I need it.

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22147
Location: Dallas, Texas


flag
PostPosted: Fri Dec 12, 2008 3:56 pm 
Post subject: Re: Universe and Data Access enhancements

But Marek, that won't work. icon_smile.gif You can't use the same key for anything other than attributes that are unique to the table. If you use a key for a value that is not unique, you get weird LOV results.

I understand where the request is coming from, and in some cases it might work, but it's not guaranteed to be correct. A simple universe like eFashion can demonstrate that.

_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19320
Location: Bratislava


flag
PostPosted: Fri Dec 12, 2008 4:18 pm 
Post subject: Re: Universe and Data Access enhancements

Dave Rathbun wrote:
...If you use a key for a value that is not unique, you get weird LOV results....
Dave, would you believe that I had discovered this problem maybe 30 minutes ago and found why it worked like that in your last-year Ninja presentation No.1 ? icon_biggrin.gif
_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22147
Location: Dallas, Texas


flag
PostPosted: Fri Dec 12, 2008 6:05 pm 
Post subject: Re: Universe and Data Access enhancements

Yes. Yes, I would. icon_smile.gif
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
itsani07
Senior Member
Senior Member



Joined: 09 Jul 2007

Posts: 56



PostPosted: Tue Dec 30, 2008 12:20 am 
Post subject: Re: Universe and Data Access enhancements

Idea : to have an "awareness" functionality on conformed dimensions.

When we have conformed dimensions in a data model, we tend to create aliases for the tables in the schema. Each alias would have to be created as a class to be used with different scenarios.

Instead, if we could have just one class for the conformed dimension and use a kind of @aware(Alias_manualErr.description, AliasEngineerErr.description, Alias_MobileErr.description) and the right column or columns would get picked based on the objects chosen from ManualErr and/or EngineerErr and/or MobileErr tables.

The point here is that these are not measure and need not be aggregated. But to reduce the number of redundant classes that needs to be created based on aliases. Making desinger more intelligent.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6635
Location: Connecticut, USA


flag
PostPosted: Tue Dec 30, 2008 12:45 pm 
Post subject: Re: Universe and Data Access enhancements

Universe-defined report-level variables. Smart Measures are close, but not quite there.

Improved List View and Context Edit dialog - ability to sort and filter the list of joins by table name.

Ability to sort objects and subclasses in a class.

Auto detection of Aggregate Navigation.

Better SQL editor - syntax coloring, table/column/class windows that don't have to be scrolled on every use.

Merge support - allow multiple developers to work on a universe, then merge changes into a single version.

Get rid of the "Groups" list when exporting!

Ability to store Connections in universe folders, and inherit the parent folder's rights.

Ability to associate universes with preferred Job Servers or Server Groups.

Ability to add a table by name, rather than scrolling through a list.

Direct support for database links.

Define objects to automatically include Predefined Conditions in reports when they are added (giving the user the ability to remove the Condition if so desired).

General PIA fixes - if I'm editing the SELECT of an object, alt-tab away, then alt-tab back, cursor moves to "Name" field and highlights it.

Ability to set which parse warnings are displayed.

Better Help - why, why, why is there nothing in Help about @Prompt syntax?

I could go on icon_smile.gif

Joe
Back to top
dnewton
Forum Addict
Forum Addict



Joined: 30 Jan 2004
ASUG Icon
Posts: 3458
Location: Massachusetts, USA


flag
PostPosted: Tue Jan 20, 2009 5:19 pm 
Post subject: Re: Universe and Data Access enhancements

dnewton wrote:
Provide a way to let the Universe layer talk to more than one database/data source. I think this really means baking the Data Federator product into the Universe layer.



Better hurry, BO/SAP: MicroStrategy just implemented this feature in their core BI product.

http://www.intelligententerprise.com/showArticle.jhtml?articleID=212900588
Back to top
fta
Senior Member
Senior Member



Joined: 16 Nov 2006

Posts: 64


flag
PostPosted: Tue Feb 17, 2009 8:26 am 
Post subject: Re: Universe and Data Access enhancements

The advantage would be that you could have schedule queries, and you have multiple reports using the same query.

I remember that in the past you could do something with Impromptu (Cognos). A queryresult (report) could be reused in another report.



dnewton wrote:
Idea: Reusable queries. (This is a grey area between report design and Universe design) I'd like to create a query with complex filtering (WHERE clause) logic, and then reuse that query across 3 separate reports. If I change the single query, all downstream reports would be affected.

This could be hacked by using QaaWS, but I'd like to see it a standalone thing, a sort of "Query Publisher" and then a webi data provider could simply point at a Query and not just a Universe.
Back to top
LANFIELD
Principal Member
Principal Member



Joined: 18 May 2006
ASUG Icon
Posts: 496
Location: SIMI VALLEY, CA


flag
PostPosted: Tue Feb 17, 2009 10:40 am 
Post subject: Re: Universe and Data Access enhancements

dnewton wrote:
Idea: Reusable queries. (This is a grey area between report design and Universe design) I'd like to create a query with complex filtering (WHERE clause) logic, and then reuse that query across 3 separate reports. If I change the single query, all downstream reports would be affected.

This could be hacked by using QaaWS, but I'd like to see it a standalone thing, a sort of "Query Publisher" and then a webi data provider could simply point at a Query and not just a Universe.


they had this in seagate info they were called views. you could even run the "view" on a schedule and the view data would be shared in many reoprts. like a little snapshot.

_________________
DANIEL FIELDS.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 4 All times are GMT - 5 Hours
Goto page 1, 2, 3, 4  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0903 seconds using 17 queries. (SQL 0.0032 Parse 0.0594 Other 0.0276)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo