I would suggest, considering that you may be working with thousands of rows, using connections (qaaws / liveoffice) for this.
One way of doing it would be to pass the dates from your calendar components as input values into the query to return only the relevant data.
In response to your other questions:
Yes that can be done using either a push or toggle using DV (dynamic visibility). Although I think you need 2 Calendars, 1 for start date, and 1 for end date.
You can bind the selected date to a cell which is used as an input value on your connection (if you create one). If using only static Excel data then you’ll need to use the calendar date as a lookup against your data.
I’m assuming here that you need to need to limit the date ranges on the calendar based upon a year. This can be done by using the calendar limits on the component, and bind these to cells. For example if you had a combo box containing years, the selected item from this would use the same cell as the calendar limit years.
Using dynamic visibility it is working fine, but having 1 prob, when Again I am clicking on the button calender not appearing, Hope now I can implement the same.
Yes I need two calender components for Start & End date.
Right now I am concentrate on static data only, so really it will work nice and I will implement the same.
But I will come to you again for dynamic data.
Yes I will use the calender limit option. Its great. At present my doubts are clear. Will come soon…
I have a set of data which is sorted by Location / Product/ Year.
I wants to display year wise Total. But my Year is not in sorting order (1).
Is there any function available to do the same.
Actually my requirement is When I will open DashBoard irrespective of any filter Current Year Data will show. I can handle my requirements now, as you guide me a lot, but facing problem due to data sorting issue.
Theres no easy way to sort data within Xcelsius unfortunately, however if you just want the default combo selection to be the current year you can use the dynamic selected item (combo properties\behaviour\common) and bind this to a cell that contains the current year, with the formula =YEAR(TODAY()).
If you are looking to access large amounts of data (1000’s of rows), please be aware that Xcelsius is more of a data visualization tool.
Some solutions
Use QaaWS/Live Office with prompts, brings small blocks of data into Xcelsius
BI Web Services, alternative to Live Office in 3.1 SP2 and above
XWIS from Antivis (http://www.antivia.com) - Connectvity/Productivity tool for Xcelsius that will save you alot of hard work and can handle tens of thousands of rows of data making you dashboard development alot easier.
I will Select 2 Dates from calender control and In between 2 Data ranges data needs to show in report as a Average value. I tried it with AVERAGEIF, but Xcelsius doesnot support AVERAGEIF. Its working well with SUMIF. Is there any option to do the same.
we will run the dashboard from Infoview. On each gauge we have some analysis button. When we click on the analysis button it will open webi report with the parameter provided in dashboard.
(In webi parameter will pass in report lavel, in Query lavel we will not pass any parameter)
Now in webi, we can change the parameter, see the report, and that parameter value will be updated in dashboard (vice versa) when we exit from webi.
I dont know how to implement this.
One more requirement, I am sending you the snapshot of the dashboard which I implemented, in left panel parameter list is displayed. Can we design the same parameter list in webi. Instead of report lavel filter we will use this filter. This parameter panel will be customised in webi.
The only way I know of doing this is by using content linking within the dashboard builder (included with premium and edge editions I believe). Do a search to get some more information on this.
For the other question look at using input controls in your Webi doc to produce the parameter list.
What I normally do with this situation is use 3 push button components.
The first one (start date) will have an on/off source range, the second one will have an off/on source range, that way both components DV can be controlled via both push buttons.
The third one uses a off/off range and is simply used to turn DV off on both.
Create an XML map from your excel spreadsheet (there are posts in this thread explaining how to do that). Then use an XML maps connection in xcelsius to connect to the data.
Shouldn’t be a problem. Test it with a dummy spreadsheet first - or copy yours to a different name. There’s a post on here that links to an external site that explains exactly how to generate an excel map - if I can do it, anybody can!
I have tried with Xml Data, but its not working for me. Can you please guide me with some screen shots or some fruitful links which way I should start. I stuck with Excel file connections and tried several times but still in same position.
That’s about as much detail as I have. I tried to step through all the issues I had from the first post when I hadn’t a clue what I was doing to the end when I had it working. The external link is very good if you follow the demo.
(BOB member since 2002-08-19)