olap and web components

olap and web components

Post by sekha » Tue, 27 Aug 2002 16:58:37



hi,

OLAP cubes created in sql2000 analysis services can be
viewed with interactivity and graphics using excel and
HTML through the msowc.cab (the pivot table concept).

However if the client PC does not have msoffice 2000 or
msoffice 97(with web components) then the cube cannot be
viewed on html. It will give a message use IE4.01 and
above and office web components.

Is there a solution to view cubes with interactivity and
graphics without installing office web components in the
local client PC ( the office web components is a licensed
software)

Thanks in advance,
sekhar

 
 
 

olap and web components

Post by partymonke » Wed, 28 Aug 2002 13:42:58


Two options:

1) License a tool (such as Proclarity, OWC, many others)...

2) Code your own front-end.   (This is not a trivial undertaking, but you
can look at an example of how to approach a very basic browser by looking at
the sample asp olap web browser provided in the SQL Server 2000 resource
kit).  You can also use XMLA to simplify accessing data from the cubes, but
you still need to build all of the interactivity and graphics.


Quote:> hi,

> OLAP cubes created in sql2000 analysis services can be
> viewed with interactivity and graphics using excel and
> HTML through the msowc.cab (the pivot table concept).

> However if the client PC does not have msoffice 2000 or
> msoffice 97(with web components) then the cube cannot be
> viewed on html. It will give a message use IE4.01 and
> above and office web components.

> Is there a solution to view cubes with interactivity and
> graphics without installing office web components in the
> local client PC ( the office web components is a licensed
> software)

> Thanks in advance,
> sekhar


 
 
 

1. OLAP Number Formats with Office Web Components

The PivotTable control(ActiveX) does not use the
Formatted_Value cell property.
With  e.g. MyPT.ActiveView.UseProviderFormatting=true,
this will result in measures being displayed as left
justified text.

With method:

set cs = createobject("ADOMD.Cellset")
   set cs.ActiveConnection = pt.Connection
   cs.Open _
   "select " & _
   "AddCalculatedMembers(Measures.members) " & _
   "on columns " & _
   "from " & CubeName & " " & _
   "cell properties format_string "
   for i = 0 to cs.axes(0).Positions.Count - 1
      totalName = cs.axes(0).Positions(i).Members
(0).UniqueName
      MyPT.ActiveView.Totals(totalName).NumberFormat = _
          cs(i).Properties("FORMAT_STRING")
   next

only "Normal Measures" are formatted, Calculated members
are not formatted.

Question1: What's the correct Syntax for formatting
Calculated members?

Question2: With set cs = createobject("ADOMD.Cellset") an
ActiveX control is created.
What's the way to avoid the security warning for the
ActiveX control?

Many Thanks to all.

2. ODBC Question

3. Connect to an OLAP cube via SERVER-SIDE scripting using Pivot Table Web Component

4. uniqueidentifier

5. Office web component printing problem / olap report tool

6. tdatetimepicker stackoverflow??

7. Excel Web Components and SQL Server OLAP

8. error-tracking

9. Request help sorting with Office 2k Web Components PivotTable and OLAP Data Source

10. OLAP & Office 2000 Web Components - Error

11. Office 2000 Web Components - OLAP Cube

12. WEB OLAP - MOVE YOUR OLAP EXPERTISE TO THE WEB