| |
|
Data Dynamics Analysis Support
Started by JoshGiftRap at 11-24-2009 8:00 AM. Topic has 9 replies.
  
|
|
Sort Posts:
|
|
|
|
 11-24-2009, 8:00 AM
|
JoshGiftRap
Joined on 11-24-2009
Posts 4
|
Web PivotView Problem: Cannot drag and drop from schema to shelves after switching cubes
|
|
|
|
|
When connecting to a MS SSAS 2005 Database that contains multiple cubes, only the first cube selected works. Switching to another cube using the cube combo box will properly load the schema but at that point, the user is unable to drag the schema from most of the elements (dimensions and measures).
The only code is in the page load event, which is mostly just the code shown in the example:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If (PivotView1.DataSource Is Nothing) Then
Dim lDatasource As DataDynamics.Analysis.DataSources.MdxDataSource = New DataDynamics.Analysis.DataSources.MdxDataSource()
lDatasource.ConnectionString = "Provider=msolap.3;Data Source=DEV-JP\SQL2008;Initial Catalog=RoxAnalysis"
lDatasource.Connect()
PivotView1.DataSource = lDatasource
End If
End Sub
I have performed the following test to try and isolate the problem:
1. Connect to a Database with 3 Cubes named A,B,and C.
2. PivotView control defaults to selecting cube A first.
3. Cube A functions properly.
4. Switching to Cubes B and C exhibits problems mentioned previously.
5. Delete Cube A from the database.
6. Connect to the database again.
7. PivotView control defaults to selecting Cube B first.
8. Cube B functions properly.
9. Switching to cube C exhibits problems mentioned previously.
|
|
|
|
|
Report
|
|
|
|
|
11-25-2009, 5:51 AM
|
SankalpS
Joined on 12-11-2008
Posts 2,587
|
Re: Web PivotView Problem: Cannot drag and drop from schema to shelves after switching cubes
|
|
|
|
|
|
JoshGiftRap,
Could you please let us know the build of Data Dynamics Analysis you are using? I used the latest build 1.0.634.0 to test the issue but could not replicate it. Are you not able to drag any of the dimensions or measures when when you switch to a different cube? I just want to clarify this as you have mentioned that this is happening with most of the elements.
Also after deleting the first cube do we need to disconnect the connection and reestablish it? Are you able to replicate the same issue with .ddacube files and with windows application? I would appreciate if you could clarify these points so that I may try replicating the issue at my end.
Regards,
Sankalp
Sankalp Sen
GrapeCity- DataDynamics
|
|
|
|
|
Report
|
|
|
|
|
11-25-2009, 7:33 AM
|
JoshGiftRap
Joined on 11-24-2009
Posts 4
|
Re: Web PivotView Problem: Cannot drag and drop from schema to shelves after switching cubes
|
|
|
|
|
|
I am using build 1.0.634.0.
I have been able to drag a dimension or two but never a measure.
In my testing I disconnected/reconnected after deleting the first cube.
I have not tested with .ddacube files.
I tested the problem in a winforms application and cannot reproduce it. It manifests only in the web version of the PivotView.
Thank you for the assistance, please let me know if you need any more information.
|
|
|
|
|
Report
|
|
|
|
|
11-30-2009, 5:16 AM
|
SankalpS
Joined on 12-11-2008
Posts 2,587
|
Re: Web PivotView Problem: Cannot drag and drop from schema to shelves after switching cubes
|
|
|
|
|
|
JoshGiftRap,
Thank you for providing the detailed information about the steps to reproduce the issue. I would be testing this issue by creating a web application and try to replicate the results which you are getting. I would request you to kindly provide me some more time to work on this and I will be posting my observations soon.
Regards,
Sankalp
Sankalp Sen
GrapeCity- DataDynamics
|
|
|
|
|
Report
|
|
|
|
|
12-03-2009, 4:51 AM
|
GauravC
Joined on 12-11-2008
Posts 579
|
Re: Web PivotView Problem: Cannot drag and drop from schema to shelves after switching cubes
|
|
|
|
|
|
JoshGiftRap,
You have mentioned in your initial post that when you connect to the second cube then the schema is loading fine but the user is not able to drag and drop attributes or measures. Can you please let me know whether you get any warning or error message when you do so? Is this behavior is persistent or random in nature?
Thanks,
Gaurav
|
|
|
|
|
Report
|
|
|
|
|
12-03-2009, 7:28 AM
|
JoshGiftRap
Joined on 11-24-2009
Posts 4
|
Re: Web PivotView Problem: Cannot drag and drop from schema to shelves after switching cubes
|
|
|
|
|
|
No warning or error messages are received.
The behavior is persistent.
|
|
|
|
|
Report
|
|
|
|
|
12-08-2009, 2:04 AM
|
Amit Pal
Joined on 12-11-2008
Posts 864
|
Re: Web PivotView Problem: Cannot drag and drop from schema to shelves after switching cubes
|
|
|
|
|
|
Hello,
I have tried this and could not see the issue which you are reporting.
Can you attach a small sample on how are you changing cubes and why only schema is getting loaded and not the data?
Amit Pal
GrapeCity- DataDynamics
|
|
|
|
|
Report
|
|
|
|
|
12-08-2009, 6:40 AM
|
JoshGiftRap
Joined on 11-24-2009
Posts 4
|
Re: Web PivotView Problem: Cannot drag and drop from schema to shelves after switching cubes
|
|
|
|
|
|
You can use the sample that ships with Data Dynamics Analysis to reproduce the problem; however, you need to connect to a datasource that contains more than one cube.
I am using the "Select a Cube" combo box control of the PivotView to change cubes (no code involved).
|
|
|
|
|
Report
|
|
|
|
|
12-09-2009, 3:17 AM
|
AashishB
Joined on 12-11-2008
Posts 818
|
Re: Web PivotView Problem: Cannot drag and drop from schema to shelves after switching cubes
|
|
|
|
|
|
Hello,
Thank you for all the details. I have been able to replicate this issue. I have opened Case 140008 for our developers to fix this issue. I have also added your email to the list of affected customers by this issue. You would be notified once the build containing the fix for this issue is released.
Regards,
Aashish
|
|
|
|
|
Report
|
|
|
|
|
04-20-2010, 5:34 AM
|
Amit Pal
Joined on 12-11-2008
Posts 864
|
Re: Web PivotView Problem: Cannot drag and drop from schema to shelves after switching cubes
|
|
|
|
|
|
Hello,
Case 140008 (You can now drag and drop items from the schema to shelves after switching cubes) has been fixed in the latest version of Data Dynamics Analysis (1.0.912.0).
You may download this build from here:
http://www.datadynamics.com/Products/DDA/Releases.aspx
Amit Pal
GrapeCity- DataDynamics
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » Data Dynamics A... » Web PivotView Problem: Cannot drag and drop from schema to shelves after switching cubes
|
|
|
|
|