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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Problem in cube creation

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
 

Following the link, http://www.sqlcoffee.com/AnalysisServices_0001.htm

i successfully did finished with the project using Adventure DB.

But when tried to make a cube using other DB, its not succeeding.

Like , during the creation of Cube, the main fields including key fields used to link tables were not appearing in the 'Select Measures' page.

Ex. there are 6 tables.

Invoice, InvoiceRow, Customer, Items, CustomerGroup, ItemGroup.

The links are like 

Invoice.InvNum = InvoiceRow.InvNum

Invoice.Cus = Customer.Code

InvoiceRow.Item = Items.Code

Customer.GrpCode = CustomerGroup.Code

Items.GrpCode = ItemGroup.Code

the following fields are not appearing in the measures list,

Invoice.CusName, Invoice.InvNum, Customer.Name, CustomerGroup.Name, Items.Name, ItemGroup.Name.

 

Is there any where im going wrong ??

Please Advice....

 


--------------------------- Radhai Krish | Golden Age is no more far | --------------------------


View Complete Post


More Related Resource Links

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  

Symbol.Keyboard.KeyPad() object creation problem

  
on windows mobile 6.5 application running on Windows mobile 6 professional VGA emulator. I am trying to work on keyboard functionality like function key press events. I have coded the below line.   Symbol.Keyboard.KeyPad keypad = new Symbol.Keyboard.KeyPad();   keypad.KeyStateNotify +=new Symbol.Keyboard.KeyPad.KeyboardEventHandler(keypad_KeyStateNotify); keypad.AlphaNotify +=new Symbol.Keyboard.KeyPad.KeyboardEventHandler(keypad_AlphaNotify);   Its build successfully but raising exception at runtime. please help me out to run this code on emulator. because i don't have device.

PS2007/MSSQL2008: Cube Creation fails, although it was OK before (CBSASConnectionFailure (17003))

  
Hi folks, about 1,5 months ago I have set up a - 1 server - development environment for PS2007. I had installed all components on one Windows 2008 box. Everything worked fine, now I receive an error. MOSS 2007 SQL 2008 SP1 MOPS 2007 SP2 I have done the additional installation for the cube building part according to this page http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx Microsoft SQL Server Native Client (sqlncli.msi) Microsoft SQL Server 2005 Management Objects Collection (sqlserver2005_xmo.msi) Microsoft SQL Server 2005 Backwards Compatibility Components (SQLServer2005_BC.msi) Everything worked fine. Cubes were able to be built.. everything was good. In order to have Reports built I added SSRS 2008 Reporting Services Addin for MOSS (rsSharePoint_x64) Business Intelligence Development Studio (=Visual Studio for MSSQL) No CUs have been added to this box. NOW, Cube creation fails with the error: ULS LOG: [CBS] ProjectServerOlapCubeGenerator status: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <IPADDRESS>. Error: ActiveX component can't create object 08efbc13-299a-4abe-9021-c46887ca6915 Eventlog says: SSP Name: SharedServices1 PSError: CBSASConnectionFailure (17003) Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error: S

PS2007/MSSQL2008: Cube creation fails although it was OK before (CBSASConnectionFailure (17003))

  
Hi folks, about 1,5 months ago I have set up a - 1 server - development environment for PS2007. I had installed all components on one Windows 2008 box. Everything worked fine, now I receive an error. MOSS 2007 SQL 2008 SP1 MOPS 2007 SP2 I have done the additional installation for the cube building part according to this page http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx Microsoft SQL Server Native Client (sqlncli.msi) Microsoft SQL Server 2005 Management Objects Collection (sqlserver2005_xmo.msi) Microsoft SQL Server 2005 Backwards Compatibility Components (SQLServer2005_BC.msi) Everything worked fine. Cubes were able to be built.. everything was good. In order to have Reports built I added SSRS 2008 Reporting Services Addin for MOSS (rsSharePoint_x64) Business Intelligence Development Studio (=Visual Studio for MSSQL) No CUs have been added to this box. NOW, Cube creation fails with the error: ULS LOG: [CBS] ProjectServerOlapCubeGenerator status: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <IPADDRESS>. Error: ActiveX component can't create object 08efbc13-299a-4abe-9021-c46887ca6915 Eventlog says: SSP Name: SharedServices1 PSError: CBSASConnectionFailure (17003) Cube build failed to connect to the Analysis Services server. Verify the data source connection is valid. Error:

problem with sitemap schema 'xsi:schemaLocation' in XML file creation

  
SqlConnection conn = new SqlConnection(connStr); conn.Open(); string sql = "select top 10 catnum,cast(case when isnull(onhand,0) < 5 then 0 else round((onhand/2),1) end as int) as onhand from dbo.V_OnHand with (nolock)"; SqlCommand cmd = new SqlCommand(sql, conn); XmlDocument doc = new XmlDocument(); XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", "UTF-8", null); XmlElement rootNode = doc.CreateElement("inventory"); doc.InsertBefore(dec, doc.DocumentElement); rootNode.SetAttribute("xmlns", "http://seller.marketplace.tests.com/inventory/v1"); rootNode.SetAttribute("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance"); rootNode.SetAttribute("xsi:schemaLocation", "http://sellersupport.domain.test.com/test1/s/schema/inventory/inventory-xml-feed-v1.xsd"); doc.AppendChild(rootNode); XmlElement fbm = doc.CreateElement("inventory"); doc.DocumentElement.PrependChild(fbm); SqlDataReader rdr1 = cmd.ExecuteReader(); while (rdr1.Read()) { XmlElement item = doc.CreateElement("item"); item.Set

Error querying SSAS cube.....permission problem???

  
I've been developing a BI solution with SQL/SSRS/SSAS 2005.  I've done all the development with an account that has full admin permissions on the server.  Now I am trying to give users access to the data without admin permissions.  When a user runs an SSRS report that queries an SSAS cube I get the following error:   An error has occurred during report processing. (rsProcessingAborted)  Query execution failed for data set 'Division'. (rsErrorExecutingCommand). Since I don't get this message when I run the report I'm thinking it's a permission thing.  I set up a domain user group, 'SQL Users', and gave them access to the SQL Server Reports database and the Report Manager but don't know if I have to grant permissions on the SSAS database.  SSAS doesn't use the same security settings that SQL uses.  I added SQL Users as a role in my database but that didn't help. I'm not sure what else to try...

Dynamic Text Boxes Creation Problem

  
Hi all, I am creating 5 textboxes in a row. A new creates when user press enter in the last textbox. I have taken a hidden text field and in OnKeyDown of last textbox I am assigning the combination of last textbox Id with the table count  to the hidden field and in VB Code I am checking whether the tableCount + Last textbox Id is equal to the hidden field or not then only I am generating the new row. here is the code In JavaScript On KeyDown of remarks textfield. function funcNewRow(id,count,e) {    var e = event || evt;    var charCode = e.which || e.keyCode;    if(charCode == 13){      e = cancelKey(e);      htxtBox.value = id + count;    } }   In VB Page_load method calling getTableRow() method   if htxtBox.value = "remarks" & (Tbl.Rows.Count + ViewState("TotalClearedItems")) Then  Tbl.Rows.Add(GetTableRow(Tbl.Rows.Count + 1 + ViewState(Panel1.Controls.Add(Tbl))  Panel1.Controls.add(Tbl) htxtBox.Value = "" end if   Here I have to implement a clear functionality such as each row at last contains a check box when user click the check box and press clear button the checked rows have to deleted .   The clear button code as follows : cnt = CInt(Tbl.Rows.Count)  For i = cnt To 1 Step -1 c = Pag

Snapshot creation problem

  

Hello,

On  this code which has been provided by Alok I get an exception at the statement marked below. The exception message is also provided. The strangest thing is that the Snapshot IS created. The original DB is NOT read only but the snapshot is.

public void CreateSnapshotAlok ( string SourceDatabaseName )
        {
            ProvideSecurity.provideSecurity ( );
            DoServer.GetSrvConnOrSwitch ( "master" );
            /* This is to ensure that a database with same name does not exist which is not needed if one chooses unique name for snapshot each time.*/
            if ( Globals.srv.Databases[ SourceDatabaseName + "_Snapshot" ] != null )
            {
                Globals.srv.Databases[ SourceDatabaseName + "_Snapshot" ].Drop ( );
            }
  

Cube creation from multiple data sources

  

Hi,

I have to design a cube that is using multiple data sources to fetch the data.

Is there a way, to connect to 2 data souces and create the data source view (.dsv) ?

Please suggest!!

Thanks


Report Server Project DataSet creation problem

  

I am getting an error while trying to create a dataset in SSRS.

 

"An error occurred while loading the query designer 'OLEDB-MD'. Only text based query designer will be loaded."

 

The "Query Designer" command is getting disabled.

 

FYI: I was able to create successful connection while created the shared DataSource to the AS db, which I used to create my dataset.

 

Please guide me in getting through this error..

 

Thanks in advance

Amber


Problem with site creation by applying custom site template

  

Hi All,

 

 I am trying to create a sharepoint teamsite with the custom features such as teamsocumentlibrary, teamtasks, teamdiscussions, teamAnnouncements, teamevents, teamslinks. When I try to create I alwys get "#140001: The parent of the page, sps/teamspace/Freigegebene Dokumente/Forms/AllItems.aspx, is not in the structure store." I can't understand this my onet.xml is starts with <Project Title="$Resources:onet_TeamWebSite;" Revision="2" ListDir="$Resources:core,lists_Folder;" xmlns:ows="Microsoft SharePoint" Url="sps/teamspace"> and all the lists has the Url startswith "sps/teamspace/listName". 

 

Does anyone have any idea. If I try to create a site with another sitetemplate it works fine. 

 

I can't find more information about this in google as well. Any expericens please help.

 

 

Thanks in advance.


Single User MySite Creation problem

  
Yeah... So I left the company I work for about 8 months ago, and came back to it about 2 months ago.  During my absence, my teammates deleted my AD account (as they should have).  Let me preface this by saying that MySite creation works for everyone else but me.

When I click on MySite I get the create My Site page, I can choose my language, but after pressing OK, I get this error:  "There has been an error creating the personal site. Contact your site administrator for more information."

I'm really not sure where to start on this one...  And am willing to give up quickly and just rename my account.  Does anyone have any ideas before I go that route?

-Dave

Problem of processing a cube

  

Hello,


I had a problem when I wanted to process a cube in SSAS 2008, I changed a SSIS package that supplies a table in SQL Server

Problem to group radio button across gridview rows

  
In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

Regrading Sharpoint 2010 problem and solutions

  
http://emanonsolutions.blogspot.com/
We can write your question and problem on this blogger.you get ans.use.

This sharpoint 2010 problem solving threads

  
Hi friend,

you can use this thread to solving problem and solutions.

Virtual Path Problem

  

 I get the following error on last line below (working on remote host): 'E:\web\sfcascom\ls_admin/uploads/images/001.JPG' is not a valid virtual path,

Note that the slashes go in different directions

I've tried a number of things but nothing seems to work. Thanks-

 

Imports System.Drawing
Imports System.Drawing.Drawing2D
Imports System.Drawing.Imaging
Imports System.Web.UI.WebControls

Imports System.Drawing.Imaging.ImageCodecInfo
Partial Class Protected_imageupload
    Inherits System.Web.UI.Page
    Private Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click
        ' Initialize variables
        Dim sSavePath As String
        Dim sThumbExtension As String
        Dim intThumbWidth As Integer
        Dim intThumbHeight As Integer
        Dim sFilename As String = ""
        ' Set constant values
        'sSavePath = "images/"
        sSavePath = Server.MapPath("~/") + "ls_admin/uploads/images/"



        sThumbExtension = "_thumb"
        intThumbWidth = 160
        intThumbHeight = 120

        ' If file field isn?t empty
        If FilUpload.PostedFile IsNot Nothing Then
            ' Check file size (mustn?t be 0)
            Dim myFile As Http
Categories: 
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