SAP Community Network Forums » Crystal Reports, Xcelsius and Interactive Analysis » Xcelsius

Thread: Dashboards for Multiple Clients

This question is not answered.


Permlink Replies: 4 - Pages: 1 - Last Post: Nov 4, 2009 7:52 PM Last Post By: Nameesh Jain
Nameesh Jain

Posts: 3
Registered: 10/20/09
Forum Points: 0
 
Dashboards for Multiple Clients  
Posted: Nov 4, 2009 6:01 PM
Click to report abuse...   Click to reply to this thread Reply
HI

I am using Boxi R2 with Xcelsius 2008 and oracle db.

I have a Unv which has table names starting with xxx.tablename.Think of this as a core Universe. We have more than 100 clients

Now if we need to deploy this Universe to our clients, we just rename the XXX. with the client Schema name and also change the connection and name of the Universe based on the client requirements, and then deploy the Universe for the client.

Now we need to build some live dashboards in Xcelsius and give it to our clients. So if I build my dashboard on core Universe with XXX.table name, how can I deploy this on clients machine.

Means how can i replace xxx.table name with the client schemnaname.table name and also the universe properties/Qaaws connection.

Thanks
AUTigerFan

Posts: 56
Registered: 1/23/09
Forum Points: 64
 
Re: Dashboards for Multiple Clients  
Posted: Nov 4, 2009 6:11 PM   in response to: Nameesh Jain in response to: Nameesh Jain
Click to report abuse...   Click to reply to this thread Reply
the Xcelsius connection (whether it's LiveOffice or QaaWS) should not care about the schema name because it's only connection is to the universe. so you shouldn't have any problem.
Nameesh Jain

Posts: 3
Registered: 10/20/09
Forum Points: 0
 
Re: Dashboards for Multiple Clients  
Posted: Nov 4, 2009 6:29 PM   in response to: AUTigerFan in response to: AUTigerFan
Click to report abuse...   Click to reply to this thread Reply
Hi

My Core universe has connection, universe name and tables starting with XXX. Now based on client we change all this information and then only give the Universe to the client.

Now If my Qaaws is built on core Universe which has xxx, How will it work for my 100 clients. ( in other words how that xxx will be replaced 100 times based on the client database information)

I will make my dashboard based on xxx. generate the swf . Now how will this work for my clients which has different database information.

Thanks

Edited by: Nameesh Jain on Nov 4, 2009 6:29 PM
AUTigerFan

Posts: 56
Registered: 1/23/09
Forum Points: 64
 
Re: Dashboards for Multiple Clients  
Posted: Nov 4, 2009 7:19 PM   in response to: Nameesh Jain in response to: Nameesh Jain
Click to report abuse...   Click to reply to this thread Reply
so if i understand, you have a database that may have a table.... let's say CORE.CUSTOMER and you have a universe developed that references the CORE.CUSTOMER table. at some point you change the database owner or schema so that now the table is ABC.CUSTOMER then you update the universe to reflect this change...... is this correct? if so then QaaWS doesn't care about that because it's connection is to the universe objects, not the database objects.

as long as you don't change the universe name you should be fine.
Nameesh Jain

Posts: 3
Registered: 10/20/09
Forum Points: 0
 
Re: Dashboards for Multiple Clients  
Posted: Nov 4, 2009 7:49 PM   in response to: AUTigerFan in response to: AUTigerFan
Click to report abuse...   Click to reply to this thread Reply
Hi

Thats correct. We did change the database tables like this.

But at the same time we do also change the connection string and the universe name. say core_unvconnection to abc_unvconnection and core Universe to abc universe.
Since the universe is built on core, the object sql will contain that. We do changes in Universe objects also.

thanks


Point your RSS reader here for a feed of the latest messages in all forums