HTTP 500 Errors in Dashboard and ASP.NET 32-bit Mode

Over the past few years, I’ve seen a few instances where ProClarity Dashboard and Kerberos just don’t seem to get along – no matter how much configuration or troubleshooting is performed.  One of the symptoms I see is an HTTP 500 error when users try to browse the Dashboard.  Our esteemed Sean Flanagan recently solved a similar case and…

0

ProClarity Install Prerequisites – PTS for SQL Server 2005

With the release of Windows 7, and client workstations trending to a 64-bit operating system, inquiries about ProClarity installation prerequisites have steadily increased.  ProClarity Professional includes ‘SQLServer2005_ASOLEDB9.msi’ which is the 32-bit version of the Analysis Services 9.0 OLE DB Provider.  The installer attempts to install this as a prerequisite before installing ProClarity Professional, and on a 64-bit…

0

ProClarity 6.3 Service Pack 3 Available

ProClarity 6.3 SP3 reached RTM on Friday, October 9, and is now available on the Microsoft Download Center: ·         ProClarity Analytics Server 6.3 SP3 (ENU). This package includes the components for updating ProClarity Analytics Server 6.3 and for distributing an updated version of ProClarity Professional 6.3. ·         ProClarity Desktop Professional 6.3 SP3 (ENU). This package…

0

Understanding ProClarity’s Metadata Store

What is ProClarity’s metadata store?  Metadata store is a fancy name for they way ProClarity products store data about your data.  In this case, your data is your Briefing Book pages and your My Views pages.  The data about your pages includes information such as the SSAS servers, databases, cubes, attributes, hierarchies, and members queried…

0

"Warning The security database on the server does not have a computer account for this workstation trust relationship."

Last November I wrote a post about an error when trying to connect ProClarity Professional to SSAS servers.  “Warning  The security database on the server does not have a computer account for this workstation trust relationship.” Well, on my Windows 7 RC and RTM machines, I was getting the same error when trying to connect to some…

0

Updated Paper on Aggregations in ProClarity 6.3 – SCOPE_ISOLATION

I’ve updated our paper on aggregation in ProClarity 6.3.  I’ve added information on the SCOPE_ISOLATION property. In Analysis Services 2000, all calculations were evaluated in the same calculation pass – unless a specific solve order was specified in the calculated member definition.  This means that the query scoped MDX could specify a different solve order…

3

Value formatting based on client machine locale

In Analysis Services 2000 the vast majority of query and calculation work was done on the client machine via Pivot Table Services.  This included numeric value formatting, and so the client machine locale id was taken into account when the formatting was done.  This meant that a client machine with a US locale id and…

0

Opening a Customized ProClarity Professional Client in a Browser Part 1

Customers may want to launch ProClarity Professional and customize the experience for the end users.  For example, they may want to open Pro in a frame in a portal and open a specific view – hiding the toolbar, Briefing Book pane, or Open Cube options in the process.   One of the most common ways of launching a customized…

2

Extranet access to ProClarity Analytics Server Using ISA Server 2006 and Kerberos

See attached Word document for some good information on ISA server, Kerberos and ProClarity. Sean Flanagan [MSFT]   “Summary One of the most common case subjects at Microsoft support is with regard to permissions being passed from one server to another in a distributed environment.  Security best practices recommend that company web servers be separated from database…

1

Can I Connect ProClarity to SSAS Without a Domain?

The bottom line on connecting to SSAS is that you need some sort of trusted Windows authentication. When you don’t have a domain, this means that you will need to use Pass-Through authentication. You will need to have matching usernames and passwords on both the client machines and the SSAS box. In ProClarity Desktop &…

0