.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Channel Sales cube

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :Sql Server

Hi, I have the Adventure works SSAS database, in object explorer, clicking on the "cubes" node, I can see 2 cubes, 1 is Ade....Works, a 2nd named Mined customers.

However, when I connect using MDX studio or click on new query inside SSAS, I have a window where I see a combobox titled "Cube" where I can see several itesm (Adv ...Works, Channel sales, Direct sales........).

Where do those cubes come from and why I can not see them unde object explorer of SSAS  .


Thanks in advance

View Complete Post

More Related Resource Links

{ End Bracket }: Tune in to Channel 9


If you fly United Airlines, you can hear what's going on in the cockpit by turning the radio dial to Channel 9. Now if you want to get inside the head of Microsoft you can tune to Channel 9 on the MSDN Web site (see http://channel9.

MSDN Magazine September 2004

Secure It: WS-Security and Remoting Channel Sinks Give Message-Level Security to Your SOAP Packets


As more organizations adopt XML-based Web Services, the need for message-level security has become evident. WS-Security, now supported in the Microsoft .NET Framework, addresses this need. Using the WS-Security framework, developers can implement channel sinks to intercept Remoting messages as they pass through the .NET Remoting infrastructure. The sink can read the message, change it, and pass it along. During this process, the message can be signed for added security. This article explains how to implement a Remoting channel sink that will modify the Remoting message by including a UserName token in the header, then sign the body using the token.

Neeraj Srivastava

MSDN Magazine November 2003

.NET Remoting: Secure Your .NET Remoting Traffic by Writing an Asymmetric Encryption Channel Sink


As .NET Remoting gains popularity in the enterprise space, it must meet business demands for trustworthy computing. Remoting traffic can be secured when objects are hosted in IIS, but when they aren't hosted in IIS, custom security solutions can be developed to secure them. This article provides an in-depth look at writing channel sinks for .NET. It also details the flow of data through custom channel sinks and explains the kinds of manipulations that can be performed on that data.

Stephen Toub

MSDN Magazine June 2003

Getting SessionID from channel


I need to set ASP.NET_SessionId in order to dowload a file from server.

I use the following code

IContextChannel mychannel = (IContextChannel)myService;
using (OperationContextScope scope = new OperationContextScope(mychannel))
  res = myService.DoSomething();
  System.ServiceModel.Channels.MessageProperties messageProperties = System.ServiceModel.OperationContext.Current.IncomingMessageProperties;
  if (messageProperties.Count > 0)
    HttpResponseMessageProperty httpResponseMessageProperty = (HttpResponseMessageProperty)messageProperties[HttpResponseMessageProperty.Name];
  if (httpResponseMessageProperty != null)
  sessionCoookie = httpResponseMessageProperty.Headers[System.Net.HttpResponseHeader.SetCookie];

It works fine if I use basicHttpBinder.Security.Message.ClientCredentialType = BasicHttpMessageCredentialType.UserName;

But when I use windows authentication (basicHttpBinder.Security.Transport.ClientCredentialType = HttpClientCredentialType.Windows;), there are 2 message responses.

The first one HTTP/1.1 401 Unauthorized with "Set-Cookie: ASP.NET_SessionId=sa34zv55sndjgq55fqzaw5ii; path=/; HttpOnly", I can see it in Fiddler and the second one with "WWW-Authenticate: Negotiate oYGgMIGdoAMKAQChCwYJKoZIgvcS

Hands-On Lab: Building Solutions with Access 2010 (Channel 9)

The objectives of this Hands-On Lab are to acquaint you with the new developer related features of Access 2010 with a keen emphasis on understanding the differences between developing database objects that will work in a Web database versus objects that work only in a client database.

Microsoft SharePoint 2010 Developer Training Course (Channel 9)

SharePoint 2010 provides a platform for developers to rapidly build solutions using familiar tools while leveraging a rich set of out-of-the-box features. Visual Studio 2010 and SharePoint Designer 2010 make developers even more productive. Find videos and presentations here to help you get started.

Download: SharePoint 2010 Developer Presentations for Channel 9

Download all of the PowerPoint presentations used in the SharePoint 2010 Learning Course on Channel 9.

Getting Below error while accessing SQL server cube

Getting Below error while accessing SQL server cube   Error Generating Drop Down Values   Odbc driver returned an error (SQLExecDirectW).   Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. URL: http://SIMAPPWQS99/olap/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000) SQL Issued: SELECT "- AppReceivedTimeYQMDD"."Year" FROM "Medicare E2E Tracking" ORDER BY 1

Clustering on cube slices

Hi, I would like to use the clustering algorithm "seperately" on each cube slice.  The problem description: Having many employes and their arrival-to-work time I created a cube with a fact table and 3 dimensions: Employee, Time, Office and I would like to run the clustering algorithm seperately for each employee to receive his arrival-to-work clusters and to find his exceptions e.g., for the employee John who has the following arrival time records: 08:05, 07:55, 8:10, 8:07, 10:30, 10:31, 10:28, 15:00 I want to receive two clusters, the first one will include  08:05, 07:55, 8:10, 8:07 The second one will include 10:30, 10:31, 10:28 (and the exception will be 15:00) Having many employees I would like to create one data mining model and to use the cube slice and dice options    Searching the web and the MSDN I didn't find whether and how it can be done - I will very appreciate your help   Thanks in advance, Lora

Restore - Cube Analysis Services 2005

Hi, I'm from Brazil. Sorry for my English. I made a backup for my cube that has more than 2 GB, but de backup is created with only 50 mb. The backup don't showed erro message. I restored this backup without erro, but when I tryed query the cube, i receive this message: The query could not be processed: o File system error: The following file is corrupted: Physical file: \\?\C:\SQL Server\MSSQL.2\OLAP\Data\teste.59.db\"Nome_Servidor" - "Nome_Database".190.cub\Fato Inadimplencia Safra Contrato.190.det\Fato Inadimplencia Safra Contrato.167.prt\172.fact.data. Logical file . Someone can help? I realy need make this backup.Fabrício França Lima | MCP, MCTS, MCITP | Visite meu site: http://fabriciodba.spaces.live.com/ | Dicas de artigos SQL: Siga-me no twitter @fabriciodba.

Cube Processing Error

Hi All when i process the cube some times i get the error  "OLE DB or ODBC  Error: Operation Cancelled; HY008. Internal Error: The Operation Terminated unsuccessfully  " https://connect.microsoft.com/SQLServer/feedback/details/286505/error-in-processing-cube?wa=wsignin1.0 In above link Microsoft they said to increase Query time out, i made it 0 even it repros I am using SQL Server 2008.   Thanks

Instant Refreshment of Cube

HI All, Is that possible cube get refreshed as soon as data updated into the relation database?   Kindly Suggest Regards Amit

How to determine when the cube refresh has completed?

I'm trying run code after a cube refresh is completed, but I can't seem to figure out how to write code to determine when the cube refresh has been completed. If it were a simple calculation, I could use the code below to determine the "calculation state", but there doesn't seem to be "refresh state" that I'm aware of. Any help will be GREATLY appreciated!! Application.CalculationState = xlDone

OLE DB Error: Network-Related or Instance-Specific while Deploying SSAS 2008 Cube

Hi, I encountered the below listed error while attempting to deploy SSAS 2008 DB: Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [5]. ; 08001.  0 0  I am running a standalone MSSQL 2008 named instance on Windows Server 2008 R2. Here are the steps I have taken but yet the issue is not resolve: 1) Enable Remote connections on the server 2) Enable TCP\IP 3) SQL Browser is Running 4) Set Firewall Inbound Exceptions for SQL Browser, Default Port 1433, UDP Port 1434 5) Using Management Studio I can successfully connect to the MSSQL named instance from the app server 6) I can ping I MSSQL box from the app server 7) Read and implemented all steps in the MSDN post below: http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx Thanks for your help.

Problem in Cube processing

Hi All, I have created cube and processed with the setting "Stop Logging",and it would take 30 min to complete processing with the error shown  Error in Olap storage engine The attribute key cannot found when processing table "Factcalldata", column programid,value 7070.the attribute is Programid.   Kindly let me know is this is the reason which is responsible for Longer processing Time ,i have created partition and aggregation in all measure groups.   Regards Amit  

Creating a 3D cube and display content on each side

Dear all, I would like to show different content in each of a cube face that I can manipulated in space. My customer has see this in a desktop 3 D application somewhere on the net and would like to have this integrated in my applciation I am really interresting to integrate this has it is a good customer but have never done it Does any one have a done this already or sample for doing it ? regards SergeYour knowledge is enhanced by that of others.

Retrieve cube data directly from Relational database - is this possible?

I have a cube created in SSAS R2 2008. Now i would like to retrieve some data from this cube, using MDX language, and then to process it in Relational SQL database! Is this possible? I am new in SSAS, please help!  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend