Welcome, Guest
Username Password: Remember me
  • Page:
  • 1

TOPIC: Can't browse cube

Can't browse cube 7 years ago #193

I have been unable to browse cubes on my newly installed server.
I can browse the dimensions, process the cube successfully, and query the underlying database.
I am the administrator of the machine.
I'm pretty much out of ideas.

When I try to browse I get the message:

===================================
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (Microsoft SQL Server Management Studio)
------------------------------
Program Location:
at System.Windows.Forms.UnsafeNativeMethods.CoCreateInstance(Guid& clsid, Object punkOuter, Int32 context, Guid& iid)
at System.Windows.Forms.AxHost.CreateWithoutLicense(Guid clsid)
at System.Windows.Forms.AxHost.CreateWithLicense(String license, Guid clsid)
at System.Windows.Forms.AxHost.CreateInstanceCore(Guid clsid)
at System.Windows.Forms.AxHost.CreateInstance()
at System.Windows.Forms.AxHost.GetOcxCreate()
at System.Windows.Forms.AxHost.TransitionUpTo(Int32 state)
at System.Windows.Forms.AxHost.CreateHandle()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at Microsoft.AnalysisServices.Browse.BrowserHostControl.LoadBrowser()


If I try to reconnect I get this:
===================================
Exception of type 'System.Windows.Forms.AxHost+InvalidActiveXStateException' was thrown. (Microsoft SQL Server Management Studio)
------------------------------
Program Location:
at AxMicrosoft.Office.Interop.Owc11.AxPivotTable.set_Selection(Object value)
at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdatePivotTable(Boolean translate)
at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdateAll(Boolean translate)
at Microsoft.AnalysisServices.Browse.CubeBrowser.ReconnectCanFail()
at Microsoft.AnalysisServices.Browse.CubeBrowser.SupportFunctionWhichCanFail(FunctionWhichCanFail function)


I ran a Profiler trace on the process and a portion of the results are attached - it's too big for this post:
<?xml version="1.0" encoding="utf-16" ?>
- <TraceData xmlns="tempuri.org/TracePersistence.xsd">
- <Header>
<TraceProvider name="Microsoft Analysis Services" MajorVersion="9" MinorVersion="0" BuildNumber="3054" />
<ServerInformation name="SERVER_NAME" />
- <ProfilerUI>
</ProfilerUI>
</Header>
- <Events>
- <Event id="41" name="Existing Connection">
<Column id="3" name="StartTime">2007-11-09T07:52:43-05:00</Column>
<Column id="35" name="ClientHostName">127.0.0.1:2363</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="36" name="ClientProcessID">2532</Column>
<Column id="25" name="ConnectionID">60</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="37" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
</Event>
- <Event id="42" name="Existing Session">
<Column id="28" name="DatabaseName">TestFromEdsMachine</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="36" name="ClientProcessID">2532</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="5" name="Duration">3704547</Column>
<Column id="25" name="ConnectionID">60</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="37" name="ApplicationName">Microsoft SQL Server Management Studio - Query</Column>
<Column id="41" name="SPID">1840</Column>
<Column id="45" name="RequestProperties"><PropertyList><Catalog>TestFromEdsMachine</Catalog><Timeout>0</Timeout><Content>SchemaData</Content><Format>Tabular</Format><AxisFormat>TupleFormat</AxisFormat><BeginRange>-1</BeginRange><EndRange>-1</EndRange><ShowHiddenCubes>false</ShowHiddenCubes><VisualMode>0</VisualMode><DbpropMsmdFlattened2>false</DbpropMsmdFlattened2><SspropInitAppName>Microsoft SQL Server Management Studio - Query</SspropInitAppName><SecuredCellValue>0</SecuredCellValue><ImpactAnalysis>false</ImpactAnalysis><SQLQueryMode>Calculated</SQLQueryMode><ClientProcessID>2532</ClientProcessID><ReturnCellProperties>false</ReturnCellProperties><CommitTimeout>0</CommitTimeout><ForceCommitTimeout>0</ForceCommitTimeout><ExecutionMode>Execute</ExecutionMode><RealTimeOlap>false</RealTimeOlap><MdxMissingMemberMode>Default</MdxMissingMemberMode><DisablePrefetchFacts>false</DisablePrefetchFacts><LocaleIdentifier>1033</LocaleIdentifier></PropertyList></Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="6" name="CPUTime">0</Column>
<Column id="42" name="TextData">*,role</Column>
<Column id="3" name="StartTime">2007-11-09T07:52:43-05:00</Column>
<Column id="35" name="ClientHostName">127.0.0.1:2363</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
</Event>
- <Event id="42" name="Existing Session">
<Column id="28" name="DatabaseName">CubeTest</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="36" name="ClientProcessID">2532</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="5" name="Duration">4255828</Column>
<Column id="25" name="ConnectionID">51</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="37" name="ApplicationName">Microsoft SQL Server Management Studio</Column>
<Column id="41" name="SPID">1660</Column>
<Column id="45" name="RequestProperties"><PropertyList><Catalog>CubeTest</Catalog><Timeout>15</Timeout><Content>SchemaData</Content><Format>Tabular</Format><AxisFormat>TupleFormat</AxisFormat><BeginRange>-1</BeginRange><EndRange>-1</EndRange><ShowHiddenCubes>true</ShowHiddenCubes><VisualMode>0</VisualMode><DbpropMsmdFlattened2>false</DbpropMsmdFlattened2><SspropInitAppName>Microsoft SQL Server Management Studio</SspropInitAppName><SecuredCellValue>0</SecuredCellValue><ImpactAnalysis>false</ImpactAnalysis><SQLQueryMode>Calculated</SQLQueryMode><ClientProcessID>2532</ClientProcessID><ReturnCellProperties>false</ReturnCellProperties><CommitTimeout>0</CommitTimeout><ForceCommitTimeout>0</ForceCommitTimeout><ExecutionMode>Execute</ExecutionMode><RealTimeOlap>false</RealTimeOlap><MdxMissingMemberMode>Default</MdxMissingMemberMode><DisablePrefetchFacts>false</DisablePrefetchFacts><LocaleIdentifier>1033</LocaleIdentifier></PropertyList></Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="6" name="CPUTime">0</Column>
<Column id="42" name="TextData">*</Column>
<Column id="3" name="StartTime">2007-11-09T07:43:32-05:00</Column>
<Column id="35" name="ClientHostName">127.0.0.1:2356</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
</Event>
- <Event id="42" name="Existing Session">
<Column id="3" name="StartTime">2007-11-09T07:43:32-05:00</Column>
<Column id="35" name="ClientHostName">127.0.0.1:2357</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="36" name="ClientProcessID">2532</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="5" name="Duration">4255813</Column>
<Column id="25" name="ConnectionID">55</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="37" name="ApplicationName">Microsoft SQL Server Management Studio</Column>
<Column id="41" name="SPID">1663</Column>
<Column id="45" name="RequestProperties"><PropertyList><Catalog>CubeTest</Catalog><Timeout>15</Timeout><ShowHiddenCubes>true</ShowHiddenCubes><SspropInitAppName>Microsoft SQL Server Management Studio</SspropInitAppName><ClientProcessID>2532</ClientProcessID><LocaleIdentifier>1033</LocaleIdentifier></PropertyList></Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="6" name="CPUTime">0</Column>
</Event>
- <Event id="1" name="Audit Login">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="23" name="Success">1</Column>
<Column id="35" name="ClientHostName">127.0.0.1:2430</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
</Event>
- <Event id="36" name="Discover Begin">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...t></Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="45" name="RequestProperties"><PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...opInitAppName>SQL Server Profiler - 9f3db6bc-cc8c-408f-b3fa-8331a286cc5b</SspropInitAppName><ClientProcessID>4348</ClientProcessID><LocaleIdentifier>1033</LocaleIdentifier></PropertyList></Column>
</Event>
- <Event id="38" name="Discover End">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="23" name="Success">1</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="4" name="EndTime">2007-11-09T08:54:28-05:00</Column>
<Column id="24" name="Error">0</Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="5" name="Duration">16</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="6" name="CPUTime">16</Column>
<Column id="22" name="Severity">0</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...t></Column>
</Event>
- <Event id="36" name="Discover Begin">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...t></Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="45" name="RequestProperties"><PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...opInitAppName>SQL Server Profiler - 9f3db6bc-cc8c-408f-b3fa-8331a286cc5b</SspropInitAppName><ClientProcessID>4348</ClientProcessID><LocaleIdentifier>1033</LocaleIdentifier></PropertyList></Column>
</Event>
- <Event id="38" name="Discover End">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="23" name="Success">1</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="4" name="EndTime">2007-11-09T08:54:28-05:00</Column>
<Column id="24" name="Error">0</Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="5" name="Duration">0</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="6" name="CPUTime">0</Column>
<Column id="22" name="Severity">0</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...t></Column>
</Event>
- <Event id="36" name="Discover Begin">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...t></Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="45" name="RequestProperties"><PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...opInitAppName>SQL Server Profiler - 9f3db6bc-cc8c-408f-b3fa-8331a286cc5b</SspropInitAppName><ClientProcessID>4348</ClientProcessID><LocaleIdentifier>1033</LocaleIdentifier></PropertyList></Column>
</Event>
- <Event id="38" name="Discover End">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="23" name="Success">1</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="4" name="EndTime">2007-11-09T08:54:28-05:00</Column>
<Column id="24" name="Error">0</Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="5" name="Duration">0</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="6" name="CPUTime">0</Column>
<Column id="22" name="Severity">0</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...t></Column>
</Event>
- <Event id="36" name="Discover Begin">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...t></Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="45" name="RequestProperties"><PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...opInitAppName>SQL Server Profiler - 9f3db6bc-cc8c-408f-b3fa-8331a286cc5b</SspropInitAppName><ClientProcessID>4348</ClientProcessID><LocaleIdentifier>1033</LocaleIdentifier></PropertyList></Column>
</Event>
- <Event id="38" name="Discover End">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="23" name="Success">1</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="4" name="EndTime">2007-11-09T08:54:28-05:00</Column>
<Column id="24" name="Error">0</Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="5" name="Duration">0</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="6" name="CPUTime">0</Column>
<Column id="22" name="Severity">0</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...t></Column>
</Event>
- <Event id="36" name="Discover Begin">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...t></Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="45" name="RequestProperties"><PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...opInitAppName>SQL Server Profiler - 9f3db6bc-cc8c-408f-b3fa-8331a286cc5b</SspropInitAppName><ClientProcessID>4348</ClientProcessID><LocaleIdentifier>1033</LocaleIdentifier></PropertyList></Column>
</Event>
- <Event id="38" name="Discover End">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="23" name="Success">1</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="4" name="EndTime">2007-11-09T08:54:28-05:00</Column>
<Column id="24" name="Error">0</Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="5" name="Duration">0</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="6" name="CPUTime">0</Column>
<Column id="22" name="Severity">0</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...t></Column>
</Event>
- <Event id="15" name="Command Begin">
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="8" name="SessionType">User</Column>
<Column id="28" name="DatabaseName">CubeTest</Column>
<Column id="42" name="TextData"><Batch xmlns="schemas.microsoft.com/analysisservices/2003/engine" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"><Create xmlns="schemas.microsoft.com/analysisservices/2...><Value>SQL Server Profiler - 9f3db6bc-cc8c-408f-b3fa-8331a286cc5b</Value></NotLike></Filter></Trace></ObjectDefinition></Create></Batch></Column>
<Column id="1" name="EventSubclass">12</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="45" name="RequestProperties"><PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="schemas.xmlsoap.org/soap/envelope/"...opInitAppName>SQL Server Profiler - 9f3db6bc-cc8c-408f-b3fa-8331a286cc5b</SspropInitAppName><ClientProcessID>4348</ClientProcessID><LocaleIdentifier>1033</LocaleIdentifier></PropertyList></Column>
</Event>
- <Event id="39" name="Notification">
<Column id="15" name="ObjectReference"><Object><TraceID>MicrosoftProfilerTrace1194616468</TraceID></Object></Column>
<Column id="39" name="SessionID">7607D39F-2ACE-4FBE-88C7-EE81959ADC03</Column>
<Column id="4" name="EndTime">2007-11-09T08:54:28-05:00</Column>
<Column id="12" name="ObjectType">100050</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="1" name="EventSubclass">6</Column>
<Column id="5" name="Duration">16</Column>
<Column id="13" name="ObjectName">MicrosoftProfilerTrace1194616468</Column>
<Column id="25" name="ConnectionID">114</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="41" name="SPID">2868</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:28-05:00</Column>
<Column id="10" name="IntegerData">1</Column>
<Column id="14" name="ObjectPath">SERVER_NAME.MicrosoftProfilerTrace1194616468</Column>
<Column id="3" name="StartTime">2007-11-09T08:54:28-05:00</Column>
<Column id="11" name="ObjectID">MicrosoftProfilerTrace1194616468</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
</Event>
- <Event id="2" name="Audit Logout">
<Column id="23" name="Success">1</Column>
<Column id="35" name="ClientHostName">127.0.0.1:2356</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="4" name="EndTime">2007-11-09T08:54:38-05:00</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="36" name="ClientProcessID">2532</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="5" name="Duration">4265578</Column>
<Column id="25" name="ConnectionID">51</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="37" name="ApplicationName">Microsoft SQL Server Management Studio</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:38-05:00</Column>
<Column id="6" name="CPUTime">0</Column>
</Event>
- <Event id="2" name="Audit Logout">
<Column id="23" name="Success">1</Column>
<Column id="35" name="ClientHostName">127.0.0.1:2357</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="4" name="EndTime">2007-11-09T08:54:38-05:00</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="36" name="ClientProcessID">2532</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="5" name="Duration">4265578</Column>
<Column id="25" name="ConnectionID">55</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="37" name="ApplicationName">Microsoft SQL Server Management Studio</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:38-05:00</Column>
<Column id="6" name="CPUTime">0</Column>
</Event>
- <Event id="1" name="Audit Login">
<Column id="3" name="StartTime">2007-11-09T08:54:38-05:00</Column>
<Column id="23" name="Success">1</Column>
<Column id="35" name="ClientHostName">127.0.0.1:2431</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:38-05:00</Column>
<Column id="22" name="Severity">0</Column>
<Column id="24" name="Error">0</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="25" name="ConnectionID">115</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
</Event>
- <Event id="1" name="Audit Login">
<Column id="3" name="StartTime">2007-11-09T08:54:38-05:00</Column>
<Column id="23" name="Success">1</Column>
<Column id="35" name="ClientHostName">127.0.0.1:2432</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:38-05:00</Column>
<Column id="22" name="Severity">0</Column>
<Column id="24" name="Error">0</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="25" name="ConnectionID">113</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
</Event>
- <Event id="36" name="Discover Begin">
<Column id="3" name="StartTime">2007-11-09T08:54:38-05:00</Column>
<Column id="39" name="SessionID">CB66E0CB-55E7-4CFC-A856-33D67D87344B</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="36" name="ClientProcessID">2532</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="25" name="ConnectionID">115</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="37" name="ApplicationName">Microsoft SQL Server Management Studio</Column>
<Column id="41" name="SPID">2873</Column>
<Column id="45" name="RequestProperties"><PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"> <Catalog>CubeTest</Catalog> <ShowHiddenCubes>True</ShowHiddenCubes> <SspropInitAppName>Microsoft SQL Server Management Studio</SspropInitAppName> <Timeout>15</Timeout> <LocaleIdentifier>1033</LocaleIdentifier> <ClientProcessID>2532</ClientProcessID> <Content>SchemaData</Content> <Format>Tabular</Format> </PropertyList></Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:38-05:00</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis"> <PropertyName>DBMSVersion</PropertyName> </RestrictionList></Column>
</Event>
- <Event id="38" name="Discover End">
<Column id="23" name="Success">1</Column>
<Column id="39" name="SessionID">CB66E0CB-55E7-4CFC-A856-33D67D87344B</Column>
<Column id="24" name="Error">0</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="1" name="EventSubclass">26</Column>
<Column id="5" name="Duration">0</Column>
<Column id="25" name="ConnectionID">115</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="37" name="ApplicationName">Microsoft SQL Server Management Studio</Column>
<Column id="41" name="SPID">2873</Column>
<Column id="45" name="RequestProperties"><PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"> <Catalog>CubeTest</Catalog> <ShowHiddenCubes>True</ShowHiddenCubes> <SspropInitAppName>Microsoft SQL Server Management Studio</SspropInitAppName> <Timeout>15</Timeout> <LocaleIdentifier>1033</LocaleIdentifier> <ClientProcessID>2532</ClientProcessID> <Content>SchemaData</Content> <Format>Tabular</Format> </PropertyList></Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:38-05:00</Column>
<Column id="6" name="CPUTime">0</Column>
<Column id="22" name="Severity">0</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis"> <PropertyName>DBMSVersion</PropertyName> </RestrictionList></Column>
<Column id="3" name="StartTime">2007-11-09T08:54:38-05:00</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="4" name="EndTime">2007-11-09T08:54:38-05:00</Column>
<Column id="36" name="ClientProcessID">2532</Column>
</Event>
- <Event id="43" name="Session Initialize">
<Column id="3" name="StartTime">2007-11-09T08:54:38-05:00</Column>
<Column id="35" name="ClientHostName">127.0.0.1:2431</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="28" name="DatabaseName">CubeTest</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="36" name="ClientProcessID">2532</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="25" name="ConnectionID">115</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="37" name="ApplicationName">Microsoft SQL Server Management Studio</Column>
<Column id="41" name="SPID">2873</Column>
<Column id="45" name="RequestProperties"><PropertyList><Catalog>CubeTest</Catalog><Timeout>15</Timeout><Content>SchemaData</Content><Format>Tabular</Format><AxisFormat>TupleFormat</AxisFormat><BeginRange>-1</BeginRange><EndRange>-1</EndRange><ShowHiddenCubes>true</ShowHiddenCubes><VisualMode>0</VisualMode><DbpropMsmdFlattened2>false</DbpropMsmdFlattened2><SspropInitAppName>Microsoft SQL Server Management Studio</SspropInitAppName><SecuredCellValue>0</SecuredCellValue><ImpactAnalysis>false</ImpactAnalysis><SQLQueryMode>Calculated</SQLQueryMode><ClientProcessID>2532</ClientProcessID><ReturnCellProperties>false</ReturnCellProperties><CommitTimeout>0</CommitTimeout><ForceCommitTimeout>0</ForceCommitTimeout><ExecutionMode>Execute</ExecutionMode><RealTimeOlap>false</RealTimeOlap><MdxMissingMemberMode>Default</MdxMissingMemberMode><DisablePrefetchFacts>false</DisablePrefetchFacts><LocaleIdentifier>1033</LocaleIdentifier></PropertyList></Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:38-05:00</Column>
<Column id="42" name="TextData">*</Column>
</Event>
- <Event id="36" name="Discover Begin">
<Column id="3" name="StartTime">2007-11-09T08:54:38-05:00</Column>
<Column id="39" name="SessionID">CB66E0CB-55E7-4CFC-A856-33D67D87344B</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="36" name="ClientProcessID">2532</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="1" name="EventSubclass">4</Column>
<Column id="25" name="ConnectionID">115</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="37" name="ApplicationName">Microsoft SQL Server Management Studio</Column>
<Column id="41" name="SPID">2873</Column>
<Column id="45" name="RequestProperties"><PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"> <Catalog>CubeTest</Catalog> <ShowHiddenCubes>True</ShowHiddenCubes> <SspropInitAppName>Microsoft SQL Server Management Studio</SspropInitAppName> <Timeout>15</Timeout> <LocaleIdentifier>1033</LocaleIdentifier> <ClientProcessID>2532</ClientProcessID> <Content>SchemaData</Content> <Format>Tabular</Format> </PropertyList></Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:38-05:00</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis"> <CATALOG_NAME>CubeTest</CATALOG_NAME> <CUBE_NAME>TestDataMart</CUBE_NAME> <CUBE_SOURCE>3</CUBE_SOURCE> </RestrictionList></Column>
</Event>
- <Event id="38" name="Discover End">
<Column id="23" name="Success">1</Column>
<Column id="39" name="SessionID">CB66E0CB-55E7-4CFC-A856-33D67D87344B</Column>
<Column id="24" name="Error">0</Column>
<Column id="32" name="NTUserName">eszumowski</Column>
<Column id="40" name="NTCanonicalUserName">SERVER_NAME\eszumowski</Column>
<Column id="1" name="EventSubclass">4</Column>
<Column id="5" name="Duration">16</Column>
<Column id="25" name="ConnectionID">115</Column>
<Column id="33" name="NTDomainName">SERVER_NAME</Column>
<Column id="37" name="ApplicationName">Microsoft SQL Server Management Studio</Column>
<Column id="41" name="SPID">2873</Column>
<Column id="45" name="RequestProperties"><PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"> <Catalog>CubeTest</Catalog> <ShowHiddenCubes>True</ShowHiddenCubes> <SspropInitAppName>Microsoft SQL Server Management Studio</SspropInitAppName> <Timeout>15</Timeout> <LocaleIdentifier>1033</LocaleIdentifier> <ClientProcessID>2532</ClientProcessID> <Content>SchemaData</Content> <Format>Tabular</Format> </PropertyList></Column>
<Column id="2" name="CurrentTime">2007-11-09T08:54:38-05:00</Column>
<Column id="6" name="CPUTime">16</Column>
<Column id="22" name="Severity">0</Column>
<Column id="42" name="TextData"><RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis"> <CATALOG_NAME>CubeTest</CATALOG_NAME> <CUBE_NAME>TestDataMart</CUBE_NAME> <CUBE_SOURCE>3</CUBE_SOURCE> </RestrictionList></Column>
<Column id="3" name="StartTime">2007-11-09T08:54:38-05:00</Column>
<Column id="43" name="ServerName">SERVER_NAME</Column>
<Column id="4" name="EndTime">2007-11-09T08:54:38-05:00</Column>
<Column id="36" name="ClientProcessID">2532</Column>
</Event>
</Events>
</TraceData>

Re: Can't browse cube 6 years, 5 months ago #344

  • elegantkvc
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
hi,

Check the following criterias for browsing a cube.

1.Check the user has the server role permission on the database ,he/she working
2.Check the user can login into analysis server using windows authentication.

The above conditions has to be positive for browsing a deployed cube successfully.

cheers mate
vijay
  • Page:
  • 1
Time to create page: 0.20 seconds
 

XL Cubed