BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
Hi Jadon,
Thank you for using Syncfusion products.
We have checked the sample in our 12.3.0.36 version and we couldn’t able to reproduce the reported problem at our end. We have attached a video for your convenience in the below link and we would very much appreciate if you could provide us some more details such as screen-shot or video explaining step-by-step replication procedure of the problem. This will help us to proceed further.
Also please let us know whether you are using our new ASP.NET or ASP.NET classic control.
Video Link:
https://www.syncfusion.com/downloads/support/directtrac/132663/ElementEditorWindow1854103326.zip
Please let us know if you have any concerns.
Thanks,
Alagarsamy D.
Hi Jadon,
Thanks for the screen-shot.
We have analyzed the screen-shot provided in the last update and would like to clarify/confirm that “1986” was the only value show in OLAP Grid (1st screenshot Checkbox_1.png) and we would like to know whether any prior filtering done before showing 1986 value as show in OLAP Grid (in 1st screenshot Checkbox_1.png). If so, kindly provide the complete step-by-step replication procedure as we still couldn’t able to reproduce the problem at our end.
Thanks,
Alagarsamy D.
Waiting for a gentle reply from you.
Hi Jadon,
Thanks for the update.
We have once again checked the reported scenario with our “Adventure Works DW” cube and we couldn’t able to reproduce the reported problem at our end. Normally we use “Adventure Works DW” cube as a test cube for any purpose and would ship the same while installing Essential Studio as well. Hence we now kindly recommend you to check the reported problem against “Adventure Works DW” cube by using the below connection string. If the problem still exists, please provide us a complete step-by-step replication procedure. This will help us to proceed further.
Cube installed location:
C:\Users\UserName\AppData\Local\Syncfusion\EssentialStudio\version\Common\Data\OfflineCube\ASP
Connection String:
string connectionString = @"Data Source = C:\Users\<UserName>\AppData\Local\Syncfusion\EssentialStudio\version\Common\Data\OfflineCube\ASP\Adventure_Works_Ext.Cub; Provider = MSOLAP;";
Please let us know if you have any concerns.
Thanks,
Alagarsamy D
Hi Jadon,
Thanks for the update.
Since its happening only in your case we would very much appreciate if you could provide us a sample cube with dummy/garbage values replicating the very same problem. This will help us to look into the flow to recognize the problem.
Please let us know if you have any concerns.
Thanks,
Alagarsamy D.
Hi Jadon,
Thanks for the update.
Query |
Answer |
We have two field called "Placement Date" and "Month Bin" so issue with Placement Date field where as Month Bin field is working fine all the check boxes saving correctly for month Bin field. In the code both field defined in similar manner.
|
We have analyzed the screen-shot provided in the last update and would like to inform you that "MonthBin" is an attribute hierarchy since it is having only 1 level (defined without any expander in element editor) and the "PlacementDate" element is user defined hierarchy since it is having “n” level (defined with expanders in element editor). Please refer the attached screenshot.
We kindly recommended you to check the reported problem against any other user defined hierarchy (and not attribute hierarchy) available in your cube itself and let us know on the same.
Screen-shot:
|
Could you please tell me one thing, can we manage check boxes through programming or it's internal functionality of the Sync-Fusion controls. I checked the code but I didn't find anything related to check boxes, in the code simply Dimension Element declared and Added in series or category window nothing for check boxes.
|
We have an event that would be raised while opening the element editor window. Please use this event for getting the checked state and node details while loading element editor. Please find the code snippet below.
Code Snippet [C#]:
protected void Page_Load(object sender, EventArgs e) { this.OlapClient1.MemberEditorLoading += OlapClient1_MemberEditorLoading; } void OlapClient1_MemberEditorLoading(object sender, MemberEditorLoadingEventArgs e) { var temp = e.Node.Checked; //use this code to get the current checked node status. } |
Please let us know if you have any concerns.
Thanks,
Alagarsamy D
Hi Jadon,
Thanks for the update.
We will wait until here from you.
Thanks,
Alagarsamy D
Hi Alagarsamy,
I checked the report again and found that in the report creation there is some difference in the fields that are working fine and that are not working for check boxes issue. for the Month field that is working fine the code is "
DimensionElement dimensionElementColumn = new DimensionElement();
// Specifying the name of the dimension element
dimensionElementColumn.Name = "dimMonthBin";
//dimensionElementColumn.ElementName = "Periods Since Placement";
// Specifying the hierarchy and level name
dimensionElementColumn.AddLevel("Periods Since Placement", "Periods Since Placement");"
Hi Alagarsamy,
please forget the above reply it was by mistake.
I checked the report again and found that in the report creation there is some difference in the fields that are working fine and that are not working for check boxes issue. for the Month field that is working fine the code is below-
and for the PlacementDate field that is not working the code is below-
Now if you compare the both the declarations you will find a minor difference that is in the last line in AddLevel method.
Please look at the method arguments for first code and in second code both are different.
I check this same thing in other fields also to confirm the issue the I found that the fields that have declared as Month field all working fine and fields that are declared as Placement fields not working correctly.
My means to say is where ever the dimensionElementRow.Name and the first argument of AddLevel method are same, the issue is there only.
To confirm this issue I checked the Element Editor window for both and there also some difference check the attached images for that (MonthBin.PNG, PlacementDate.PNG). Please check the red circled area.
In your last reply you explained about attribute hierarchy and User defined hierarchy so I checked that also and realize that there is no issue because of that. Only the thing is I am not passing the correct name or values in the AddLevel method.
To confirm this I had a look into yours Syncfusion Samples also, below is code from Syncfusion sample-
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the Dimension Name
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");Please have a look on dimensionElementRow.Name and AddLevel method first argument is different. In my case it is same.
For this check screenshot of your Syncfusion sample (SyncFusion_Date.PNG)
Now I want to now from where you taking the values "Date,Fiscal,Fiscal Year. Are these values coming from Cubes?
The only thing now I need to check for correct values in the cube.
I am using four Sync fusion reports and in each report using different-2 cubes. I had a look into each report. there is same issue in all the reports.
Waiting for your Response
Shreekant Jadon
Hi Jadon,
Thanks for the update.
We would like to inform you that the “MonthBin” is an
attribute hierarchy since it is having the same hierarchy and level names.
“PlacementDate” is an user defined hierarchy since it is having the different
hierarchy and level names. Since the values are obtained from cubes this
could not be an issue.
We would very much appreciate if you could provide us a
simple/dummy cube with the “Monthbin”, “PlacementData” and measures to
reproduce the reported problem. We don’t require the complete cube and you can
create a simple cube with these two dimension and measures reproducing the
issue with garbage value. This will help us to proceed further.
Please let us know if you have any concerns.
Thanks,
Alagarsamy D.
Hi
Jadon,
The
underlying values are from the cube and we aren’t manipulating anything. We
will wait for the dummy cube using which we will be able to quickly sort and
solve the problem.
Thanks,
Alagarsamy
D
Hi Jadon,
Thanks for the update.
We will wait until here from you.
Thanks,
Alagarsamy D
Hi Shreekant,
Thanks for the update.
We couldn’t be able to reproduce the reported problem and we have created a sample illustrating the same. We would very much appreciate if you could reproduce the reported problem in the attached sample with your cube having dummy values and send back to us. This will help us proceed further.
Sample:
https://www.syncfusion.com/downloads/support/forum/117701/Olapclient_snapdate1110032633.zip
Please let us know if you require any further assistance.
Thanks,
Ramesh.G
Hi Shreekant,
Thanks for the update.
We would very much appreciate if you could follow below steps.
1. Attach your cube in excel.
2. Expand the member 2015 in dimPlacementDate as you mentioned.
3. Take a screenshot and send back to us.
Also we would very much appreciate if you could provide us the member count of “2015” under dimPlacementDate. This will help us to proceed further.
Please let us know if you require further assistance on this.
Thanks,
Ramesh.G
public void OlapClient1_TreeNodeDropped(object sender, TreeNodeDroppedEventArgs e)
{
//code here
}
Drag and drop within AxisElementBuilder.
protected void Page_Load(object sender, EventArgs e)
{
//code here
this.OlapClient1.AxisElementDropped+=OlapClient1_AxisElementDropped;
}
public void OlapClient1_AxisElementDropped(object sender,AxisElementDroppedEventArgs e)
{
//code here
}
Please let us know if you require further assistance on this.
Thanks,
Ramesh G.
The function provided by you in your last reply is not available in the version 11.
Is there any other equivalent function which triggers when
we drag the dimension from CubeDimensionBrowser
to AxisElementBuilder in
version 11?
Thanks
Shreekant
Regards,
Ramesh G.
I've been updated essential studio with v.13.3.0.7 but still am not able to get the event or function provided by you for when we drag from CubeDimensionBrowser to AxisElementBuilder.
AM getting below error
Error 1 'Syncfusion.Web.UI.WebControls.Client.Olap.OlapClient' does not contain a definition for 'TreeNodeDropped' and no extension method 'TreeNodeDropped' accepting a first argument of type 'Syncfusion.Web.UI.WebControls.Client.Olap.OlapClient' could be found (are you missing a using directive or an assembly reference?)Error 2 The name 'OlapClient1_TreeNodeDropped' does not exist in the current contextIs there any namespace or assembly that am missing?Please reply with some solution as we already updated version and still running into issue.ThanksShreekant
Could you please provide us the code snippets with an example?
Thanks
Shreekant
Hi Team,
I was wondering if you have had a chance to look at my request above yet?
Many thanks,
Shreekant
[C#]
OlapReport olapReport = new OlapReport(); olapReport.Name = "Customer Report"; olapReport.CurrentCubeName = "Adventure Works";
MeasureElements measureElementColumn = new MeasureElements(); measureElementColumn.Elements.Add(new MeasureElement { Name = "Customer Count" });
DimensionElement dimensionElementRow = new DimensionElement(); dimensionElementRow.Name = "Date"; dimensionElementRow.HierarchyName = "Fiscal"; dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
DimensionElement excludedRowElement = new DimensionElement(); excludedRowElement.Name = "Date"; excludedRowElement.AddLevel("Fiscal", "Fiscal Year"); excludedRowElement.AddLevel("Fiscal", "Fiscal Semester"); excludedRowElement.Hierarchy.LevelElements["Fiscal Year"].Add(new MemberElement() { Name = "FY 2004", UniqueName = "[Date].[Fiscal].[Fiscal Year].&[2004]" }); excludedRowElement.Hierarchy.LevelElements["Fiscal Year"].Add(new MemberElement() { Name = "FY 2005", UniqueName = "[Date].[Fiscal].[Fiscal Year].&[2005]" }); excludedRowElement.Hierarchy.LevelElements["Fiscal Semester"].Add(new MemberElement() { Name = "H2 FY 2002", UniqueName = "[Date].[Fiscal].[Fiscal Semester].&[2002]&[2]" });
olapReport.CategoricalElements.Add(measureElementColumn); olapReport.SeriesElements.Add(dimensionElementRow,excludedRowElement);
return olapReport; |
Hi Shreekant,
We are unable to reproduce the reported problem at our end. So, please provide us a sample cube with dummy/garbage values which will help us to proceed further.
Regards,
Ramesh G.
S.No | Query | Response |
1. | Please find the attached screenshot of dimension. That would help you to reproduce the issue. I am facing this issue in ASP. NET Classic version 13. But this functionality is working as expected in ASP.NET version 11. | We have tested the same with the exact scenario which you have mentioned. But, still we are unable to reproduce the reported problem at our end. Please find the following video which illustrates the same. Video Link: https://www.syncfusion.com/downloads/support/forum/120913/ze/memberEditor1576116557 Please provide us a sample Cube having dummy/garbage values which will help us to proceed further. |
2. | And I have one more request that please provide us a sample where we can exclude desired members after drag and drop within AxisElementBuilder. | We have prepared a sample based on your requirement. Please find the same in the following link. Sample Link: https://www.syncfusion.com/downloads/support/forum/120913/ze/Olapclient_snapdate1020379499 |
? OLAP Report(aspx.cs): OlapReport olapReport = new OlapReport(); olapReport.Name = "Customer Report"; olapReport.CurrentCubeName = "Adventure Works"; DimensionElement dimensionElementColumn = new DimensionElement(); //Specifying the Name for the Dimension Element dimensionElementColumn.Name = "Customer"; dimensionElementColumn.HierarchyName = "Customer Geography"; dimensionElementColumn.AddLevel("Customer Geography", "Country"); MeasureElements measureElementColumn = new MeasureElements(); measureElementColumn.Elements.Add(new MeasureElement { Name = "Internet Sales Amount" }); DimensionElement dimensionElementRow = new DimensionElement(); //Specifying the Dimension Name dimensionElementRow.Name = "Date"; dimensionElementRow.AddLevel("Fiscal", "Fiscal Year"); // Adding Column Members olapReport.CategoricalElements.Add(dimensionElementColumn); ///Adding Measure Element olapReport.CategoricalElements.Add(measureElementColumn); ///Adding Row Members olapReport.SeriesElements.Add(dimensionElementRow); |
Hi Ramesh,Could you please provide us the cube which you used to reproduce the invisibility of (Blank) issue in the above attached video.Thank you,Shreekant
Please find the below links which illustrate to create a global(offline) cube.
https://msdn.microsoft.com/en-us/library/ms145581.aspx
Hi Shreekant,
We are unable to reproduce the reported problem at our end. Please find the video and sample in the following link.
Video Link: http://www.syncfusion.com/downloads/support/forum/120913/ze/sample-1630726844
Sample Link: http://www.syncfusion.com/downloads/support/forum/120913/ze/Olapclient_snapdate-1979616874
Could you reproduce the reported problem in the above sample and update us to proceed further.
Regards,
Ramesh G.