I need some help around building Hierarchical table using Xcelsius. Our project donot have SAP or BO universe. All the data comes from SQL server using xml data connection using aspx. We have option to use webservices as well but we do not have BO Universe. But to build hierarchical table, we need a query which we need to pull from BO universe(that is what I observed when I am trying to use a hierarchical table)
I would like to know how to make the hierarchical table work by feeding it from my sqlserver 2008. Please let me know! Thanks in advance.
You cannot use the Hierarchical Table component with data from Sql Server - it only works with data from a Bex query, and perhaps universe data built on an OLAP source, though I have not tested that option. It does not work with data from a relational database source.
If is unfortunate, as I have wanted to use this type of format for making selections as well on several projects. Depending upon how much data there actually is for the selection options, you may be able to achieve a similar option, just using the Scorecard or Spreadsheet table component, though it does not have the option for “folding” the data and expanding nodes.
If you want to pull data from SQL Server, you may want to look into a 3rd part tool, such as InfoBurst, which you can connect directly to the database and pass parameters back and forth from a cache of data. This would allow you to just use something simple like combo boxes to pass the user selections back to the cache and summarize the data selection that it returns (called cache queries).
I do this just with simple aspx pages, hosting raw SQL. Users selects country from list - aspx passes it back to the SQL to get the relevant cities to present to the user. User selects city… etc
As others have pointed, to use the standard hierarchical table component you need to source your data from SAP / BO. There are also inexpensive 3rd party components you could use for the same effect.
If this is not doable, even then please let me know!!
(BOB member since 2006-08-07)
(BOB member since 2005-03-01)