Hi,
In the current v3 release of the product, when I have two dimension members in a hierarchy, say company name and product name, if I expand out the all level of company, and then expand out all products, i get back all the products for all the companies. This makes for extremely long query times to our analysis server not to mention all the data being brought back if i only wanted to see the details of a particular company.
In our current asp.net application, for example, as displayed below, if I click on a particular company name, I get back only the products associated with that company, not all the products for all the companies. Is there a timeline when this feature will be implemented?
Hello,
The new 11.1 release should be available in the beginning of April, but this is still a target date and is subject to change.
Please let us know if you require any further assistance on the matter.
Sincerely,
Petar Monov
Developer Support Engineer
Infragistics Bulgaria
www.infragistics.com/support
Yes, that is the functionality we would be expecting with the cross diimensional attributes as well as you state will be released in v11.1. Is there an estimated time of this release? We really want to use this control ASAP and we currently cannot until this is released and also the fact that every member expansion causes a full query of all members.
Thanks.
sorry for the first misunderstanding. The feature that you are asking about will come up in our next release v 11.1. In the example below you can see the new expand. For example, If you want to see just Products for Pacific sales territories then you can expand only Pacific hierarchy and only the group of products related with Pacific. It is no more needed to expand All Products. Is it what you expect?
Thanks,
Dimitrina
I'm able to compile and run the new assemblies, but the functionality specified is not there unless there is a new property I am unaware of.
As an example, we have a company dimension, that has one attribute called Company Name, and a product dimension with two attributes: Product Name and Product Category. If I put Company Name from the company dimension first in the rows section, then second put product name from the product dimension, I have to expand out the "all" for both sections. Note there is not a hierachy defined at the cube level between these two dimensions. In our old asp.net cube, this did not matter. I could expand out the company and see only that companies products.
It looks like, however, it works if I use both Product Category and Product Name in the rows section that does define a hierachy between the two dimensional attributes. Expanding out the second member, however, is very slow. Looking at the SSAS trace when i expand it out looks like it is still doing a query across all members as shown below.
SELECT [Product].[Product].[ProductCategory].ALLMEMBERS DIMENSION PROPERTIES MEMBER_NAME, MEMBER_TYPE ON 0, {} ON 1 .
Note: we have been using the ADO provider that was provided some time ago since we do not want to use msmdump. Perhaps there is a new one since the inital release?
You shouldn’t have any problems even if you are compiling the source code and taking the latest versions of the dll’s. If you got the latest source code and compile it, you should recompile one by one all of the dependencies of the project and the used assemblies. Please check that you have recompiled all of the dependencies like the pivot Grid and when you deploy them, they are pointing to the updated version.
I hope this helps.
Sincerely,DimiDeveloper Support EngineerInfragistics, Inc.