Rendering Problem

08-27-2009, 10:50 PM
In the page column "Hour" is swapped by "Domain"
and in the row column in the place of "country" it
should be "Program"

Please see the code, stored proc and the sample .cub file.

DCube3.ocx version 3.3.0.1216
Please help, this matter is most urgent for me, so your
help will be greatly appreciated.

Kind Regards

Re: Rendering Problem

08-28-2009, 5:27 AM
swordfish8,

From your code I can see that you are using DynamiCube in Unbound mode and QueryByPass property doesn't have any effect in this mode. Also, I don't see how exactly you populate cube in FetchData event. Can you try to move cube to another connection type and set DCRecordSource to your stored procedure? Also, please ensure that your stored procedure returns fields in the correct order (and GROUP BY, ORDER BY clauses).

Thank you,
Andrey T.

Thank you,
Andrey T.

Re: Rendering Problem

08-28-2009, 5:42 PM
Hi Andrey,

This is how I populate the CUBE

Public Sub PopulateCube(ByRef cube As DataDynamics.DynamiCube.Interop.DCube, ByVal reader As SqlDataReader)

Debug.Assert(Not reader Is Nothing)

Dim fieldIdx As Integer
Dim row(reader.FieldCount - 1) As Object

While reader.Read
AppendCurrentRow(reader, cube)
End While

reader.Close()

End Sub

And please find attached the modified Stored Proc, I have grouped and ordered, please advice ASAP.... many thanks for your help

Re: Rendering Problem

08-31-2009, 8:52 AM
Thanks for the additional info. However we still need to see the code that is calling AddRowEx, which is apparently inside the "AppendCurrentRow" method being called in PopulateCube. Please send that. 

Almost certainly the problem is in there. Be sure that you are using AddRowEx and that the elements of the array passed to AddRowEx are in exactly the same order as the order that you added fields to DynamiCube. Based on the code you provided in SectionVisitsRegionalCube.Process, the order of the elements in the array should be as follows:  RegionalProgramName, Program, Section, EyeballCountry, ReportWeek, Region, Domain, dayOfWeek, Hour, UU

Just FYI, some related documentation topics: AddRowEx, Fields.Add, unbound example. 

Hope this helps!

Scott Willeke
GrapeCity

Re: Rendering Problem

09-03-2009, 4:30 PM
Thanks Scott, I dont use the AddRowEx
however the code is as follows:


Public Sub PopulateCube(ByRef cube As DataDynamics.DynamiCube.Interop.DCube, ByVal reader As SqlDataReader)

Debug.Assert(Not reader Is Nothing)

Dim fieldIdx As Integer
Dim row(reader.FieldCount - 1) As Object

While reader.Read
AppendCurrentRow(reader, cube)
End While

reader.Close()

End Sub

Private Sub AppendCurrentRow(ByVal reader As SqlDataReader, ByVal cube As DataDynamics.DynamiCube.Interop.DCube)
Dim fieldIdx As Integer
'array of fields to hold 1 row of data.
Dim row(reader.FieldCount - 1) As Object

For fieldIdx = 0 To reader.FieldCount - 1
row(fieldIdx) = reader.Item(fieldIdx)
Next

'Check the DynamiCube help if you don't know the difference etweek AddRow and AddRowEx as it
'is very important. AddRow is used if the data is already grouped correctly and QueryByPass
'is set to true.
cube.AddRow(row)
End Sub

NOTE: THE REST OF THE CUBES WORKS FINE. THE NEW CUBE I HAVE ADDED DOES NOT WORK.. I AM REALLY SUPRISED.... OLD CUBES WORK.... THE NEWLY ADDED CUBES DONT!!

Re: Rendering Problem

09-04-2009, 3:54 AM

swordfish8,

After further investigation I've recognized that you are experiencing this behaviour because of fieldObject.SortType = SortType.DDSTAscending fields property. If you remove these properties, then cube is populated correctly (another solution is to rollback to DynamiCube3 3.2.1.1177 build). This is definitely a bug and I've entered a Case 135320 to address this.

Thank you,
Andrey T.

Re: Rendering Problem

09-06-2009, 5:11 PM
Thanks Andrey, I have now rolled back to 3.2.1.1177 and this has fixed the problem.

Re: Rendering Problem

09-16-2009, 3:14 PM
Hi Andrey, after rolling back to 3.2.1.1177 its fixed the problem and now can generate the cubes in the required format, however, I CAN'T render the .cub files on web pages.

when I try to browse the .cub file from my web application, it prompts me to download the Activex component, I allowed it... but it does not help...

Please find a sceen shot attached,

Many thanks for your help,

Kind Regards

Re: Rendering Problem

09-16-2009, 8:54 PM

swordfish8,

What error you are receiving? Also please check that you are using the same 3.2.1.1177 DynamiCube version on Web. Please note that cube files saved with 3.3.0.1216 version and 3.2.1.1177 are not compatible, i.e. you can't open .cub file saved with 1177 version with 1216 version and vice versa.

Thank you,
Andrey T.

Re: Rendering Problem

09-20-2009, 4:57 PM
Sorry Andrey, I think I have not explained my problem clearely, I will make another try :)

Step 1:
DynamiCube 3.2.1.1177 is installed on this box.

I have application "DCubeGenerator" in vb6 which generates the .cub (CUBE) files

Step 2:
DynamiCube 3.2.1.1177 is installed on the web server as well.

After the "Step 1" the generated .cub files are copied to the server, from where
the web application runs

When the users log into the web application they can view the cubes (the .cub files) from the web application,

After I rolled back from 3.3.0.1216 to 3.2.1.1177 on my box (development) when I try to browse the .cub file from the web application, it does not render the .cub on the web page. Please see the screen shot attached.

FYI: I am using IE 8.0.6001.18702

Only on my box I am unable to browse the .cub files from the web application, this does not effect rest of the users.

NOTE: In IE Tools\Manage Add-ons (currently loaded add-ons), I cant see the DynamaciCube installation details

Hope this helps.

Kind Regards

Re: Rendering Problem

09-20-2009, 10:43 PM
swordfish8,

It looks like DynamiCube3 ActiveX doesn't installed on your browser.
Internet Explorer 8 gives users more control over where and in what context ActiveX controls will run. In Internet Explorer 8, ActiveX controls embedded as web objects are presented as add-ons. Through the new Manage Add-ons window, the registry, or ATL Site Lock, users can restrict add-ons to specific websites:
http://www.microsoft.com/windows/internet-explorer/readiness/developers-existing.aspx#activex
I'd recommend you to ensure that newer DynamiCube3 is not installed in your browser, ensure that your web page refers to right DynamiCube3 3.2.1.1177 .cab file and prompts you to download and install it first time, after this check that DynamiCube appears in Manage Add-ons window. Also please check ActiveX IE section settings and set all options in this section to Prompt or Enable and also approve DynamiCube3 on all sites via Manage Add-ons window (IE menu/Tools/Manage Add-ons).

Thank you,
Andrey T.

Re: Rendering Problem

09-30-2009, 5:07 PM
Hi Andrey,

I'd recommend you to ensure that newer DynamiCube3 is not installed in your browser.

How?

check that DynamiCube appears in Manage Add-ons window.

It does not appear in the Manage Add-ons window.

please check ActiveX IE section settings and set all options in this section to Prompt or Enable and also approve DynamiCube3 on all sites via Manage Add-ons window (IE menu/Tools/Manage Add-ons).

Yes have done this

Still cannot download the DynamiCube3 on to my system. However the DynamiCube3 3.2.1.1177 is registered on my systems, when I run the VB6 cube viewer application I can see the cube (.cub file).

Thanks

Re: Rendering Problem

10-01-2009, 10:47 PM
Hello.

In IE8 Manage Add-ons window can you please select Show: All Add-ons to check if there is DynamiCube 3 Class installed?

Thank you,
Andrey T.

Re: Rendering Problem

02-01-2011, 10:56 PM
This issue is fixed in the new DynamiCube 3.3.0.1224 build. You can download it here:
http://www.datadynamics.com/Forums/40/ShowForum.aspx

Thank you,
Andrey T.