I think your best bet is to use a relational DB of some sort instead of excel. Dashboards can only look at single sources like excel.
-----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Mr. Tee Sent: Wed 6/22/2011 6:04 AM To: [email protected] Subject: Data sources and data views in Dashboards 7.6.03 Hi ARS-LIST, I have a question regarding data sources and data views in BMC Dashboards 7.6.03. I would like to know if it is true what I experience using the pod-builder in dashboards: When creating a new pod - then I also need to create a dataview from an excel sheet data source. My experience is that I am only able to create one data view (equal to one sheet within the excel workbook) per Excel data source. I find that a bit frustrating as I have excel workbooks with for example 10 sheets that makes it necessary to create 10 datasources for 10 dataviews. That is not very smart. I would appreciate your feedback on a better way of working on this. Thanks in advance. Kind regards Mr. Tee _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

