Olap Client report: check boxes incorrectly saving

[Shreekant Jadon]

Hi All,

The state of the check boxes incorrectly saving in Element Editor window. Actually whats is going on, when I am selecting data for one year in element editor window then only that year must be selected.

So instead of that all the years are selecting in Element Editor window. 

Suppose we have data for thee year 2001,2002,2003. so I want to select  2001,2002 years of data not the all so  2001,2002  should be selected in element editor window. So Instead of that check boxes for all are selecting. it is showing like this.

Could anyone please provide any solution for it?

Thanks

Shreekant Jadon

E-Mail: [e-mail]

Mb: [phone]

  

[Alagarsamy D]

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.

[Shreekant Jadon]

Hi Alagarsamy,

First of all thanks for your reply.

In the video you showed,  you selected two years data and clicked ok so it was selecting two years data and in the element editor window it is showing only two year selected when you are going to it again.

In my case what ever data I am selecting it is working fine but when I am going to element editor window it showing all selected. It should show what data I select like in video you select two year data it is showing only two year selected. If I am unselecting all the check boxes and again going to element editor window then also it showing all selected. So the state of the check boxes not saving correctly.

Please find the attached screenshot (CheckBox.rar). There are three files in .rar folder. 

1.First (CheckBox_1) :-     Just I selected two years (2013,2014) data in element editor window and clicked ok.

2.Second(CheckBox_2):- Data populated for those two years (2013,2014) successfully.

3.third(CheckBox_3):-     When I check element editor window again, It is showing all the checkboxex selected  but it must be show only two check box for year 2013,2014 that we selected manually.

I hope you can understand now what exactly the issue is with me.  

Could you please provide any solution for it. Your help would be greatly appreciated. I am hoping a gentle reply from you as soon as you can.

Thanks

Shreekant Jadon

E-Mail: [e-mail]

Mb: [phone]

 

Attachment: CheckBox_faf735fc.rar

[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.

[Shreekant Jadon]

Hi Alagarsamy,

Thanks for your reply.

Yes we are filtering the data at load time, so when report load at first time it would select only one year data to increase the performance. you are talking about "1986", this year selected when we are coming first time to report but when I am going to element editor window it showing all years selected but it actually should show only "1986"  selected.

The screenshot that attached in last reply was the later steps, like if you want to select any more years data that's why I selected two years data  in screenshot and later things already replied.

Issue is still there check boxes not saving correctly every time it showing all selected if you select one year data, two year data and whatever.

Waiting for a gentle reply from you.

Thanks
Shreekant Jadon
E-Mail: [e-mail]
Mb: [phone]

[Shreekant Jadon]

Can someone reply please?

[Alagarsamy D]

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

[Shreekant Jadon]

Hi Alagarsamy,

Thanks for paying attention,

Please keep it simple, Now  I am explaining the issue from your view.

In your first reply you sent me a sample clip  Link: http://www.syncfusion.com/downloads/support/directtrac/132663/ElementEditorWindow1854103326.zip

please go for it and see, when it start it showing all the years check boxes selected (FY 2002, FY 2003, FY 2004, FY 2005, FY 2007`) in element editor window after that you unselect all check boxes and afterward you selected only two years check boxes (FY 2002, FY 2003) and clicked ok then data populated for those two years. All is fine till here in My case as well  but when you are again going back to element editor window then it is showing the only two years data (FY 2002, FY 2003) that is correct because you selected only two years. In my case it is not happening when I am going back it is showing all selected even if I am unselecting all or selecting one , two three year and so on. In the element editor window it should show only selected years check boxes ticked and rest should be null or unselected. 

In your case it is working fine but in my case it isn't. So how to handle it. Do I need to set any property or any code changes for it?

Looking forward to a gentle reply from you.

Thanks

Shreekant Jadon

E-Mail: [e-mail]

Mb: [phone]

[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.

[Shreekant Jadon]

Hi Team,

Sorry! I was out of station so didn't had a look into it, please reopen the issue as I got notification that issue has been closed.

The cube that we are using have the huge volume of data  so it is difficult to replace that data with dummy values. One more thing that I can provide you is, month field is working fine.

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. 

please check attached image you can find in element editor window only six month selected and in report showing correctly and check boxes selected for six only.

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.

Do these things declare in cube?

Please reply if possible 

Thanks

Shreekant Jadon

Attachment: Month_d5b2caff.rar

[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

[Shreekant Jadon]

Hi team,

Thanks for your reply,

Will do as you suggest and respond back to you soon

Thanks

Shreekant

[Alagarsamy D]

Hi Jadon,

 

Thanks for the update.

 

We will wait until here from you.

 

Thanks,

Alagarsamy D

[Shreekant Jadon]

Hi Alagarsamy,

I found something that can help me to fix this issue I think so will apply that to the reports first tomorrow.

I will keep you posted back with my findings.

Thanks

Shreekant

[Alagarsamy D]

Hi Jadon,

Thanks for the update.

Thanks,
Alagarsamy D

[Shreekant Jadon]

  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");" 

[Shreekant Jadon]

  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-

DimensionElement dimensionElementRow = new DimensionElement();
// Specifying the name of the dimension element
dimensionElementRow.Name = "dimMonthBin";
// Specifying the hierarchy and level name
dimensionElementRow.AddLevel("Periods Since Placement", "Periods Since Placement");

and for the PlacementDate field that is not working the code is below-

DimensionElement dimensionElementRow = new DimensionElement();
// Specifying the name of the dimension element
dimensionElementRow.Name = "dimPlacementDate";
// Specifying the hierarchy and level name
dimensionElementRow.AddLevel("dimPlacementDate", "Year");

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

Attachment: MonthBin_809fca66.rar

[Shreekant Jadon]

Sorry forgot to attache all the screenshot images so now attaching all in CheckBox_issue folder.

Please let me know from where the values coming, if from cubes then how to check values in cube?

Thanks

Shreekant Jadon

Attachment: CheckBox_Issue_a3c2fa8a.rar

[Alagarsamy D]

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.

[Shreekant Jadon]

Hi Alagarsamy,

Thanks for update,

I will provide you dummy cube soon as of now bit busy.

I checked some other attribute hierarchy fields Named "Agencies" and "CollectionType". 

The Attribute field Agencies not saving the check boxes correctly while Attribute field CollectionType saving the check boxes correctly.

I looked into the code for both and here also I found same issue as last time. Dimension's for both fields declared differently.

Since both are the Attribute fields so Dimension's should have declared in same manner.

Below is the code for Agencies field-   

           DimensionElement dimensionElementslicers = new DimensionElement();

            // Specifying the name of the dimension element

            dimensionElementslicers.Name = "dimAgencies";

            // Specifying the hierarchy and level name

            dimensionElementslicers.AddLevel("dimAgencies", "Agency Name");

Below is the code for CollectionType field-

           DimensionElement dimensionElementslicers4 = new DimensionElement();

            // Specifying the name of the dimension element

            dimensionElementslicers4.Name = "dimCollectionType";

            // Specifying the hierarchy and level name

            dimensionElementslicers4.AddLevel("Delinquency Stage", "Delinquency Stage");

Since both fields are attribute Hierarchy but declared differently (Check attached screenshot for this)

In my case issue is for those fields where the value for " dimensionElementslicers.Name " and "first argument of AddLevel method" are same. 

Rest of the fields are working/Saving the check boxes correctly.

Since I am working on Syncfusion controls first time so my knowledge is limited to these controls. 

Now I want to check the internal values of the dimension's in the cube and want to know that how they have declared fields in cube.

I want to know , have they declared fields in different- different style or we are making mistake in declaration?

Please Advice me, am I on the correct way?

Thanks

Shreekant Jadon  

Attachment: CheckBx_21122014_a3f7b636.rar

[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

[Shreekant Jadon]

Hi Alagarsamy,

Thanks for the reply,

Some colleagues are on vacation so bit busy that's why cube is not created yet.

I hope you understand and will provide the same soon so please don't close the issue immediately, 

if you will not hear anything from me till Monday. 

Once again thanks you very much and its really appreciated help on this.

Thanks

Shreekant Jadon  

[Alagarsamy D]

Hi Jadon,

 

Thanks for the update.

 

We will wait until here from you.

 

Thanks,

Alagarsamy D

[Shreekant Jadon]

Hi Alagarsamy,

Thanks for your help on Syncfusion controls till now.

I have one more issue.  I am using a dimension "dimPlacementDate" that is a user defined hierarchy. Since it is having "n level" (Defined with Expanders in Element Editor window). It has Years, Quarters,Months,Days available and when I am trying to expanding year "+" sign it sits in Expanding state and never returns. Actually it should expand and show all the Quarters, Months, Days properly.

Please have a look into Attached .Zip file

Could you please let me know what is causing the issue? Do I need to work on code basis?  

What is the impact of large volume of data on this? 

Waiting for your reply.

Thanks

Shreekant

Mb. 09632101643

Attachment: Expanding_Issue_6c1bb574.zip

[Ramesh Govindaraj]

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

[Shreekant Jadon]

Hi Ramesh,

Thanks for the update.

I did check your attachment sample. It is also available on the Syncfusion website in Demo of Syncfusion controls and I already checked. All the functionality is fine there. I tried it by expanding year "+"sign and same expanding in less than 1 sec but same is not happening in my case. Since I am new to Syncfusion so can't create cube and really sorry for that.

Could you please check reply of Alagarsamy of 17th December 2014 there he mentioned about the expanding the same?

In your Syncfusion Demo's you have very less data so may be because of the it is too fast. In our case we have huge amount of data so may be that is causing issue. I might be wrong  but can you please let us know ,  can huge volume of data affect it?

Please reply with a gentle solution.

Thanks

Shreekant

[Ramesh Govindaraj]

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

[Shreekant Jadon]

Hi Ramesh,

Thanks for update.

Expanding thing resolved now. I have one more question.

When we drag any dimension from cube  and drop into the Axis fields (Categorical or Series or Slicer) then which event fire.

In my case one dimension is not functioning correctly so I need to put some piece of code into that event to handle the issue.

It would be very much appreciate if you can provide some link or some online document so there I can find all the event related the sync fusion control.

So I can refer to that location when needed.

I shall be waiting for response and hoping a gentle reply.

Thanks

Shreekant

[Ramesh Govindaraj]

Hi Shreekant,

Please find the below code snippets to trigger events.

Drag from CubeDimensionBrowser and drop to AxisElementBuilder.
protected void Page_Load(object sender, EventArgs e)
{
//code here
this.OlapClient1.TreeNodeDropped+=OlapClient1_TreeNodeDropped;
}

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.

[Shreekant Jadon]

Hi Ramesh and sync fusion team,

Thanks for all your help and suggestions.

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

[Ramesh Govindaraj]

 
Hi Shreekant,

The event which we gave in our last update is available only in our recent versions. So we kindly suggest you to upgrade your version in-order to meet your requirement.

NOTE: Our Essential Studio Volume 3, 2015 (latest version) is available for download under the following link.

https://www.syncfusion.com/forums/120659/essential-studio-2015-volume-3-final-release-v13-3-0-7-is-available-for-download

Regards,

Ramesh G.

[Shreekant Jadon]

Hi Ramesh

Thanks for your reply.

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 context

Is there any namespace  or assembly that am missing?

Please reply with some solution as we already updated version and still running into issue.

Thanks

Shreekant

[Ramesh Govindaraj]

Hi Shreekant,

We are unable to reproduce the reported problem at our end. Also, we have prepared a simple sample along with the mentioned events. Please find the sample and video in the following links.

Sample Link: https://www.syncfusion.com/downloads/support/forum/117701/ze/Olapclient_snapdate821188873

Video Link: https://www.syncfusion.com/downloads/support/forum/117701/ze/events1499086143

NOTE: Please make sure all the Syncfusion libraries are pointing 13.3.0.7 version as well as web.config holding the latest version number. If still the problem exists, kindly provide us an exact sample replicating the problem. This will help us proceed further.

Regards,
Ramesh G.

[Shreekant Jadon]

Thanks Ramesh for the update.

 while installation of Essential studio we got assembly versions 4.0,4.5,4.5.1 but we are using .net version 3.5 so while adding the reference for new .dll we are getting error saying that this is the newer version that currently installed.

So can we get assembly version 3.5 for Essential studio v.13.3.0.7 ?

we thought about up gradation of .net version but we can't because of lots of dependency.

Is there any other way to resolve the issue?

We are getting below issue-

C:\Windows\Microsoft.NET\Framework\v3.5\Microsoft.Common.targets : warning MSB3246: Resolved file has a bad image, no metadata, or is otherwise inaccessible. Could not load file or 

assembly 'D:\xxx\yyy\zzz\application\bin\Syncfusion.XlsIO.Base.dll' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.

Please reply before today EOD, if possible

Thanks for all your help as always

Thanks

Shreekant

[Ramesh Govindaraj]

 
Hi Shreekant,

Whenever Essential Studio is installed, we will place all our dll’s inside the following location.
C:\Program Files (x86)\Syncfusion\Essential Studio\13.3.0.7\precompiledassemblies\13.3.0.7\

And you can find our controls .NET 3.5 framework version dll’s under the following location.
 C:\Program Files (x86)\Syncfusion\Essential Studio\13.3.0.7\precompiledassemblies\13.3.0.7\3.5
Regards,
Ramesh G.

[Shreekant Jadon]

Hi Ramesh,

Thanks for the update.

I was referring the same location and we don't have the .net 3.5 verson dll.

my location  C:\Program Files (x86)\Syncfusion\Essential Studio\13.3.0.7\Assemblies and I have only 4.0,4.5,4.5.1 

I have attached assembly.zi file please check that.

I am not sure what happened why its not coming?

Do I need to install the essential studio and install again?

but I install this on two machine's and got the same version on both.

Please suggest.

Thanks

Shreekant

Attachment: Assembly_fef9014.zip

[Shreekant Jadon]

Hi Ramesh,

I just checked below location as well but don't have .net version 3.5 dll

C:\Program Files (x86)\Syncfusion\Essential Studio\13.3.0.7\precompiledassemblies\13.3.0.7 

At above location we only have 4.0,4.5,4.5.1,4.6

Thanks

Shreekant

[Manivannan Sundararajan]

Hi Shreekant,

We are not providing the .NET Framework v3.5 support for ASP.NET platform. If you need .NET Framework v3.5 support, you need to install ASP.NET (Classic).

The below list of Syncfusion Essential Studio platforms supports .NET Framework v3.5 version.

Platforms:
1. ASP.NET (Classic)
2. ASP.NET MVC (Classic)
3. Windows Forms
4. WPF

Regards,
Manivannan S.

[Shreekant Jadon]

Hi Manivannan,

Thanks for your reply.

I got below link for the  latest version up gradation.

https://www.syncfusion.com/forums/120659/essential-studio-2015-volume-3-final-release-v13-3-0-7-is-available-for-download  

But I can't see asp.net (classic) on that page.

Could you please provide me the address from where I can download the asp.net (classic)?

Thanks

Shreekant

[Manivannan Sundararajan]

Hi Shreekant,

You can download the v13.3.0.7 ASP.NET (Classic) Syncfusion setup from the following link.

https://www.syncfusion.com/support/directtrac/downloads/13_3_0_7  

Regards,
Manivannan S.

[Shreekant Jadon]

Hi Manivannan,

Thanks for all your help on this.

I am still using .net framework 3.5 with sync fusion asp.net v 11.1.0.21 and its running fine.

so if I will upgrade sync fusion asp.net v 11.1.0.21 to sync fusion asp.net (classic) v 13.3.0.7 then will it work properly with my code?

Basically I want know what are the differences between asp.net and asp.net classic.

If you provide the input on this that would be really helpful.

Thanks

Shreekant

[Ramesh Govindaraj]

Hi Shreekant,

Yes, your requirement will be addressed on upgrading to Essential Studio ASP.NET (Classic) 13.3.0.7 version.

Also the difference between ASP.NET Classic and ASP.NET is that,

-       ASP.NET Classic is purely written in ASP.NET architecture. The web control written in this cases purely adopts to the ASP.NET page life cycle whereas

-       ASP.NET is written in JavaScript (not in ASP.NET platform) and we have extended this JavaScript control to ASP.NET platform as a wrapper.
Regards,
Ramesh G.

---

SJ Shreekant Jadon November 2, 2015 02:52 AM

Hi Ramesh,

Thanks for the update.

Now I'm able to catch the events when dragging and dropping the dimension from CubeDimensionBrowser after upgrading with Asp.net classic version 13.

It would be really helpful if you can provide some code to handle the below.

How to exclude the elements from dimension when you drag from CubeDimensionBrowser and drop to AxisElementBuilder?

Could you please provide us the code snippets with an example?

Thanks

Shreekant

---

RG Ramesh Govindaraj Syncfusion Team November 3, 2015 03:39 AM

Hi Shreekant,

We have prepared a sample where we can exclude desired members after dropping dimension from CubeDimensionBrowser to AxisElementBuilder. Please refer the following sample.

https://www.syncfusion.com/downloads/support/forum/120913/ze/Olapclient_snapdate-707743639

Regards,
Ramesh G.

---

SJ Shreekant Jadon November 4, 2015 03:01 AM

Hi Ramesh,

Thanks for the update and the code snippet.

This code is really helpful.

Thanks 

Shreekant

---

RG Ramesh Govindaraj Syncfusion Team November 5, 2015 06:55 AM

Hi Shreekant,
 
Thank you for the update.
 
Please let us know if you have any query.
 
Regards,
 
Ramesh G.

---

SJ Shreekant Jadon November 6, 2015 04:36 AM

Hi Ramesh,

I am creating OLAP client report with default dimensions and excluding some of the member elements from a dimension. 

Report is displaying correctly but when I open element editor window, it shows all the check-box selected.

I am facing this issue in ASP. NET Classic version 13. But this functionality is working as expected in ASP.NET version 11.

Code:

            DimensionElement dimensionElementColumn = new DimensionElement();            

            dimensionElementColumn.Name = "Vintage Period";            

            dimensionElementColumn.AddLevel("Vintage Period", "Vintage Periods");

            DimensionElement excludeelements = new DimensionElement();

            excludeelements.Name = "Vintage Period";

            excludeelements.AddLevel("Vintage Period", "Vintage Periods");

            

            //To show the data of first six month so excluding the rest of months

            for (int i = 7; i <= 37; i++)

            {

                   excludeelements.Hierarchy.LevelElements["Vintage Periods"].Add(i.ToString());

            }

            olapReport.CategoricalElements.Add(dimensionElementColumn, excludeelements);

Is there any extra property I need to set to make it work in ASP. NET Classic version 13.3350.0.7?

Please help me on this.

Thank you,

Shreekant

---

SJ Shreekant Jadon November 6, 2015 07:12 AM

Hi Ramesh,

Sorry that just now I noticed that with the above code report is also not populating properly in ASP.NET classic.

So please provide us the code snippets to exclude the member while loading the page in ASP.NET classic.

Thanks,

Shreekant

---

SJ Shreekant Jadon November 9, 2015 01:07 AM

Hi Team,

I was wondering if you have had a chance to look at my request above yet?

Many thanks,

Shreekant

---

SJ Shreekant Jadon November 9, 2015 06:27 AM

Hi Team,

I missed to mention excludeelements.HierarchyName = "Vintage Period";  so report was not working properly.

But check box issue(i.e. Even after excluding member; element editor shows member as selected) is still persist. 

Please help me as soon as possible.

Thanks,

Shreekant

---

RG Ramesh Govindaraj Syncfusion Team November 10, 2015 05:45 AM

Hi Shreekant,
While adding excluded members, the members Uniquename need to be mentioned along with its name. Please find the following OlapReport which illustrates on how to set the excluded members.

[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;

Regards,
Ramesh G.

---

SJ Shreekant Jadon November 13, 2015 06:59 AM

Hi Ramesh,

Thank you so much. It worked like a charm.

In between I am facing one more issue that is in year member list (Blank) is one of the member and when I load the report for first time this member will not be there in element editor. But when I open the element editor for second time (Blank) option is visible.

Please find the attached screen shot which would give you clear idea of the issue here.

Thanks,

Shreekant

Attachment: OLAP_Member_Issue_b31d5b3d.zip

---

SJ Shreekant Jadon November 16, 2015 06:35 AM

Hi Ramesh,

Is there any updates on my above request?

Thank you,

Shreekant

---

RG Ramesh Govindaraj Syncfusion Team November 16, 2015 10:38 AM

Hi ShreeKant,
 
We are analyzing on this and it will be updated on tomorrow.
 
Regards,
 
Ramesh G.

---

RG Ramesh Govindaraj Syncfusion Team November 17, 2015 07:58 AM

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.

---

SJ Shreekant Jadon November 18, 2015 06:48 AM

Hi Ramesh,

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.

And I have one more request that please provide us a sample where we can exclude desired members after drag and drop within AxisElementBuilder.

Thanks,

Shreekant

Attachment: Dim_ScreenShot_2124bb5b.zip

---

RG Ramesh Govindaraj Syncfusion Team November 19, 2015 05:33 AM

Hi Shreekant,

Please find the following response.

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

Regards,
Ramesh G.

---

SJ Shreekant Jadon November 24, 2015 05:03 AM

Hi Ramesh,

Could you please provide us the properties of Cube and Dimension which you used to create the OLAP report and also the C# code?

Thanks, 

Shreekant

---

RG Ramesh Govindaraj Syncfusion Team November 25, 2015 02:06 AM

Hi Shreekant,

 

Please find the following code[c#] to create simple OLAP Report.

 

 

?  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);

 

And also please utilize the following link which illustrates on how to frame the OLAP Report in details.

 

https://help.syncfusion.com/aspnet-classic/olapcommon/olapreport

 

Note: If provided details is different from your requirement, please share some more details of your requirement which help us to provide prompt details.

 

Regards,

Ramesh G.

---

SJ Shreekant Jadon December 3, 2015 04:42 AM

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

---

PS Prabu S Syncfusion Team replied to Shreekant Jadon December 4, 2015 01:18 PM

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

Hi Shreekant, 

We have checked the repoted scenario by changing the member type at internally (source level). So only possible to find out the exact problem, if you arrange a dummy/garbage cube which reproducing the error with blank-member.

Please let us know if you have any concerns.

Regards,

Prabu S.

---

SJ Shreekant Jadon December 9, 2015 02:50 AM

Hi Team,

I have created a dummy cube which reproducing the error with blank-member.

Could you please give me the instructions to how to export the cube and share it with you?

Thanks you,

Shreekant

---

RG Ramesh Govindaraj Syncfusion Team December 10, 2015 10:05 PM

Hi Shreekant,

Please find the below links which illustrate to create a global(offline) cube.

https://msdn.microsoft.com/en-us/library/ms145581.aspx

 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/374657f1-b96f-4543-b20c-5553a8708bb3/how-to-create-a-local-cube-file-cub-using-create-global-cube-within-a-ssis-2005-package?forum=sqlintegrationservices

Regards,
Ramesh G.

---

SJ Shreekant Jadon January 28, 2016 04:02 AM

Hi Team,

In IE-11 - When I open element editor window for a dimension with contains tree view structure, only parent nodes are displayed. Missing + symbol and and child nodes.

In Google Chrome - Child nodes and parent nodes are displaying but the display structure is not standard.

Please find the attached document which explains the issues with screenshots.

Please help me in resolving this issue in both IE and Chrome ASAP since it's very urgent.

Thank you, 

Shreekant

Attachment: Element_Editor_Issue_cdf6d600.zip

---

RG Ramesh Govindaraj Syncfusion Team January 29, 2016 04:59 AM

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. 

---

SJ Shreekant Jadon January 29, 2016 06:48 AM

Hi Ramesh,

This issue is not there in IE-8 but it's there in IE-9 and higher version.

Thank you,

Shreekant

---

RG Ramesh Govindaraj Syncfusion Team February 1, 2016 04:11 AM

Hi Shreekant,

We have already tested the reported problem with IE-11 which has been specified in the video provided in our last update. And now we have tested the same with the mentioned IE versions (above IE-8), but we are still unable to reproduce the issue. Please find the below video for your reference.

Video Link:  http://www.syncfusion.com/downloads/support/forum/120913/ze/clientClasic-1220098682

Could you please provide us your complete system configuration which would be helpful to test the reported issue with the exact environment.

Regards,
Ramesh G.

[Shreekant Jadon]

Hi Ramesh,

Thanks for the update.

Now I'm able to catch the events when dragging and dropping the dimension from CubeDimensionBrowser after upgrading with Asp.net classic version 13.

It would be really helpful if you can provide some code to handle the below.

How to exclude the elements from dimension when you drag from CubeDimensionBrowser and drop to AxisElementBuilder?

Could you please provide us the code snippets with an example?

Thanks

Shreekant

[Ramesh Govindaraj]

Hi Shreekant,

We have prepared a sample where we can exclude desired members after dropping dimension from CubeDimensionBrowser to AxisElementBuilder. Please refer the following sample.

https://www.syncfusion.com/downloads/support/forum/120913/ze/Olapclient_snapdate-707743639

Regards,
Ramesh G.

[Shreekant Jadon]

Hi Ramesh,

Thanks for the update and the code snippet.

This code is really helpful.

Thanks 

Shreekant

[Ramesh Govindaraj]

Hi Shreekant,
 
Thank you for the update.
 
Please let us know if you have any query.
 
Regards,
 
Ramesh G.

[Shreekant Jadon]

Hi Ramesh,

I am creating OLAP client report with default dimensions and excluding some of the member elements from a dimension. 

Report is displaying correctly but when I open element editor window, it shows all the check-box selected.

I am facing this issue in ASP. NET Classic version 13. But this functionality is working as expected in ASP.NET version 11.

Code:

            DimensionElement dimensionElementColumn = new DimensionElement();            

            dimensionElementColumn.Name = "Vintage Period";            

            dimensionElementColumn.AddLevel("Vintage Period", "Vintage Periods");

            DimensionElement excludeelements = new DimensionElement();

            excludeelements.Name = "Vintage Period";

            excludeelements.AddLevel("Vintage Period", "Vintage Periods");

            

            //To show the data of first six month so excluding the rest of months

            for (int i = 7; i <= 37; i++)

            {

                   excludeelements.Hierarchy.LevelElements["Vintage Periods"].Add(i.ToString());

            }

            olapReport.CategoricalElements.Add(dimensionElementColumn, excludeelements);

Is there any extra property I need to set to make it work in ASP. NET Classic version 13.3350.0.7?

Please help me on this.

Thank you,

Shreekant

[Shreekant Jadon]

Hi Ramesh,

Sorry that just now I noticed that with the above code report is also not populating properly in ASP.NET classic.

So please provide us the code snippets to exclude the member while loading the page in ASP.NET classic.

Thanks,

Shreekant

[Shreekant Jadon]

Hi Team,

I was wondering if you have had a chance to look at my request above yet?

Many thanks,

Shreekant

[Shreekant Jadon]

Hi Team,

I missed to mention excludeelements.HierarchyName = "Vintage Period";  so report was not working properly.

But check box issue(i.e. Even after excluding member; element editor shows member as selected) is still persist. 

Please help me as soon as possible.

Thanks,

Shreekant

[Ramesh Govindaraj]

Hi Shreekant,
While adding excluded members, the members Uniquename need to be mentioned along with its name. Please find the following OlapReport which illustrates on how to set the excluded members.

[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;

Regards,
Ramesh G.

[Shreekant Jadon]

Hi Ramesh,

Thank you so much. It worked like a charm.

In between I am facing one more issue that is in year member list (Blank) is one of the member and when I load the report for first time this member will not be there in element editor. But when I open the element editor for second time (Blank) option is visible.

Please find the attached screen shot which would give you clear idea of the issue here.

Thanks,

Shreekant

Attachment: OLAP_Member_Issue_b31d5b3d.zip

[Shreekant Jadon]

Hi Ramesh,

Is there any updates on my above request?

Thank you,

Shreekant

[Ramesh Govindaraj]

Hi ShreeKant,
 
We are analyzing on this and it will be updated on tomorrow.
 
Regards,
 
Ramesh G.

[Ramesh Govindaraj]

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.

[Shreekant Jadon]

Hi Ramesh,

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.

And I have one more request that please provide us a sample where we can exclude desired members after drag and drop within AxisElementBuilder.

Thanks,

Shreekant

Attachment: Dim_ScreenShot_2124bb5b.zip

[Ramesh Govindaraj]

Hi Shreekant,

Please find the following response.

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

Regards,
Ramesh G.

[Shreekant Jadon]

Hi Ramesh,

Could you please provide us the properties of Cube and Dimension which you used to create the OLAP report and also the C# code?

Thanks, 

Shreekant

[Ramesh Govindaraj]

Hi Shreekant,

 

Please find the following code[c#] to create simple OLAP Report.

 

 

?  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);

 

And also please utilize the following link which illustrates on how to frame the OLAP Report in details.

 

https://help.syncfusion.com/aspnet-classic/olapcommon/olapreport

 

Note: If provided details is different from your requirement, please share some more details of your requirement which help us to provide prompt details.

 

Regards,

Ramesh G.

[Shreekant Jadon]

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

[Prabu S]

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

Hi Shreekant, 

We have checked the repoted scenario by changing the member type at internally (source level). So only possible to find out the exact problem, if you arrange a dummy/garbage cube which reproducing the error with blank-member.

Please let us know if you have any concerns.

Regards,

Prabu S.

[Shreekant Jadon]

Hi Team,

I have created a dummy cube which reproducing the error with blank-member.

Could you please give me the instructions to how to export the cube and share it with you?

Thanks you,

Shreekant

[Ramesh Govindaraj]

Hi Shreekant,

Please find the below links which illustrate to create a global(offline) cube.

https://msdn.microsoft.com/en-us/library/ms145581.aspx

 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/374657f1-b96f-4543-b20c-5553a8708bb3/how-to-create-a-local-cube-file-cub-using-create-global-cube-within-a-ssis-2005-package?forum=sqlintegrationservices

Regards,
Ramesh G.

[Shreekant Jadon]

Hi Team,

In IE-11 - When I open element editor window for a dimension with contains tree view structure, only parent nodes are displayed. Missing + symbol and and child nodes.

In Google Chrome - Child nodes and parent nodes are displaying but the display structure is not standard.

Please find the attached document which explains the issues with screenshots.

Please help me in resolving this issue in both IE and Chrome ASAP since it's very urgent.

Thank you, 

Shreekant

Attachment: Element_Editor_Issue_cdf6d600.zip

[Ramesh Govindaraj]

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. 

[Shreekant Jadon]

Hi Ramesh,

This issue is not there in IE-8 but it's there in IE-9 and higher version.

Thank you,

Shreekant

[Ramesh Govindaraj]

Hi Shreekant,

We have already tested the reported problem with IE-11 which has been specified in the video provided in our last update. And now we have tested the same with the mentioned IE versions (above IE-8), but we are still unable to reproduce the issue. Please find the below video for your reference.

Video Link:  http://www.syncfusion.com/downloads/support/forum/120913/ze/clientClasic-1220098682

Could you please provide us your complete system configuration which would be helpful to test the reported issue with the exact environment.

Regards,
Ramesh G.