Running Cube On multiple times got error

vyanku

Hi,
I create a cube having different cubes of tables
Dtl.Cust.Ledger entry
Dtl.Vendor ledger entry
value entry
Job ledger entry
GLEntry
Purchase inv. line
Sales Inv.Line

Now when I run cube ,
At the time of creating cube of GL table through configurator it will shows me error 'Parent already exist'
Anybody facing this type of problem??

buchhot

also experienced the same problem,
any solution yet?
There hardly is a way of debugging since I think this error message comes from SQL-Server or Analysis Services.
](*,) ](*,) ](*,) ](*,)

vyanku

Hi,
U r right The message comes from SQL server.
But it is the fault of our cube. Try to delete some fields from the g\l entry cube. and run.
I create cube like this
Hope this will helpfull to u

Description
Cube
G_L Entry ("G/L Entry")
Table relations
G/L Entry <-> "G/L Account"
Measures
G_L Entry Amount
G_L Entry Credit Amount
G_L Entry Debit Amount
Functions
Balance at Date Amount: "G_L Entry Amount" per ""
Dimensions
G/L Entry."Posting Date" <-> "G_L Entry Posting Date"
G/L Account."Gen. Bus. Posting Group" <-> "Gen_ Business Posting Group"
G/L Account."Gen. Prod. Posting Group" <-> "Gen_ Product Posting Group"
G/L Entry."Source Code" <-> "Source Code"
G/L Entry."Job No." <-> "Job"
G/L Account."Income/Balance" <-> "Income_Balance"
G/L Entry."G/L Account No." <-> "G_L Account"
G/L Entry."Entry No." <-> "SBU_Project"
G/L Entry."Entry No." <-> "Employee"

G_L Budget Entry ("G/L Budget Entry")
Table relations
G/L Budget Entry <-> "G/L Account"
Measures
G_L Budget Entry Amount
Dimensions
G/L Budget Entry."Date" <-> "G_L Entry Posting Date"
G/L Account."Income/Balance" <-> "Income_Balance"
G/L Budget Entry."G/L Account No." <-> "G_L Account"
G/L Budget Entry."Budget Name" <-> "G_L Budget Name"
G/L Budget Entry."Entry No." <-> "SBU_Project"
G/L Budget Entry."Entry No." <-> "Employee"

Customer ("Customer")
Measures
Customer Credit Limit _LCY_
Dimensions
Customer."No." <-> "Customer"
Customer."No." <-> "Customer Country"
Customer."No." <-> "Customer Territory"

Detailed Cust_ Ledg_ Entry ("Detailed Cust. Ledg. Entry")
Measures
Detailed Cust_ Ledg_ Entry Amount _LCY_
Detailed Cust_ Ledg_ Entry Debit Amount _LCY_
Detailed Cust_ Ledg_ Entry Credit Amount _LCY_
Functions
Balance at Date Amount _LCY_: "Detailed Cust_ Ledg_ Entry Amount _LCY_" per ""
Dimensions
Detailed Cust. Ledg. Entry."Posting Date" <-> "Posting Date"
Detailed Cust. Ledg. Entry."Source Code" <-> "Source Code"
Detailed Cust. Ledg. Entry."Customer No." <-> "Customer"
Detailed Cust. Ledg. Entry."Customer No." <-> "Customer Country"
Detailed Cust. Ledg. Entry."Customer No." <-> "Customer Territory"
Detailed Cust. Ledg. Entry."Entry No." <-> "SBU_Project"
Detailed Cust. Ledg. Entry."Entry No." <-> "Employee"

Vendor ("Vendor")
Measures
Vendor Budgeted Amount
Dimensions
Vendor."No." <-> "Vendor"
Vendor."No." <-> "Vendor Country"
Vendor."No." <-> "Vendor Territory"

Detailed Vendor Ledg_ Entry ("Detailed Vendor Ledg. Entry")
Measures
Detailed Vendor Ledg_ Entry Amount _LCY_
Detailed Vendor Ledg_ Entry Debit Amount _LCY_
Detailed Vendor Ledg_ Entry Credit Amount _LCY_
Functions
Balance at Date Amount _LCY_: "Detailed Vendor Ledg_ Entry Amount _LCY_" per ""
Dimensions
Detailed Vendor Ledg. Entry."Posting Date" <-> "Posting Date"
Detailed Vendor Ledg. Entry."Source Code" <-> "Source Code"
Detailed Vendor Ledg. Entry."Vendor No." <-> "Vendor"
Detailed Vendor Ledg. Entry."Vendor No." <-> "Vendor Country"
Detailed Vendor Ledg. Entry."Vendor No." <-> "Vendor Territory"
Detailed Vendor Ledg. Entry."Entry No." <-> "SBU_Project"
Detailed Vendor Ledg. Entry."Entry No." <-> "Employee"

Item Ledger Entry ("Item Ledger Entry")
Table relations
Item Ledger Entry <-> "Item"
Measures
Item Ledger Entry Quantity
Functions
Balance at Date Quantity: "Item Ledger Entry Quantity" per ""
Dimensions
Item Ledger Entry."Posting Date" <-> "Posting Date"
Item Ledger Entry."Item No." <-> "Item"
Item Ledger Entry."Location Code" <-> "Location"
Item."Vendor No." <-> "Vendor"
Item."Inventory Posting Group" <-> "Inventory Posting Group"
Item Ledger Entry."Entry Type" <-> "Entry Type"
Item Ledger Entry."Entry No." <-> "SBU_Project"
Item Ledger Entry."Entry No." <-> "Employee"

Value Entry ("Value Entry")
Table relations
Value Entry <-> "Item"
Measures
Value Entry Cost Amount _Actual_
Value Entry Valued Quantity
Value Entry Invoiced Quantity
Value Entry Cost Posted to G_L
Functions
Balance at Date Cost Amount _Actual_: "Value Entry Cost Amount _Actual_" per ""
Dimensions
Value Entry."Posting Date" <-> "Value Entry Posting Date"
Value Entry."Item No." <-> "Item"
Value Entry."Location Code" <-> "Location"
Value Entry."Source Code" <-> "Source Code"
Item."Vendor No." <-> "Vendor"
Value Entry."Inventory Posting Group" <-> "Inventory Posting Group"
Value Entry."Item Ledger Entry Type" <-> "Item Ledger Entry Type"
Value Entry."Entry Type" <-> "Value Entry Entry Type"
Value Entry."Entry No." <-> "SBU_Project"
Value Entry."Entry No." <-> "Employee"

Job Ledger Entry ("Job Ledger Entry")
Table relations
Job Ledger Entry <-> "Job"
Measures
Job Ledger Entry Total Cost
Job Ledger Entry Quantity
Job Ledger Entry Total Price
Dimensions
Job Ledger Entry."Posting Date" <-> "Posting Date"
Job Ledger Entry."Gen. Bus. Posting Group" <-> "Gen_ Business Posting Group"
Job Ledger Entry."Gen. Prod. Posting Group" <-> "Gen_ Product Posting Group"
Job Ledger Entry."Source Code" <-> "Source Code"
Job."Bill-to Customer No." <-> "Customer"
Job."Bill-to Customer No." <-> "Customer Country"
Job."Bill-to Customer No." <-> "Customer Territory"
Job Ledger Entry."Job No." <-> "Job"
Job Ledger Entry."Phase Code" <-> "Phase"
Job Ledger Entry."Task Code" <-> "Task"
Job Ledger Entry."Step Code" <-> "Step"
Job Ledger Entry."Entry No." <-> "SBU_Project"
Job Ledger Entry."Entry No." <-> "Employee"

Res_ Ledger Entry ("Res. Ledger Entry")
Table relations
Res. Ledger Entry <-> "Resource"
Measures
Res_ Ledger Entry Total Cost
Res_ Ledger Entry Quantity
Res_ Ledger Entry Total Price
Dimensions
Res. Ledger Entry."Posting Date" <-> "Posting Date"
Res. Ledger Entry."Gen. Bus. Posting Group" <-> "Gen_ Business Posting Group"
Res. Ledger Entry."Gen. Prod. Posting Group" <-> "Gen_ Product Posting Group"
Res. Ledger Entry."Source Code" <-> "Source Code"
Res. Ledger Entry."Resource No." <-> "Resource"
Res. Ledger Entry."Job No." <-> "Job"
Res. Ledger Entry."Entry No." <-> "SBU_Project"
Res. Ledger Entry."Entry No." <-> "Employee"

Opportunity Entry ("Opportunity Entry")
Table relations
Opportunity Entry <-> "Campaign"
Measures
Opportunity Entry Estimated Value _LCY_
Opportunity Entry Calcd_ Current Value _LCY_
Opportunity Entry Entry No_
Dimensions
Opportunity Entry."Estimated Close Date" <-> "Estimated Close Date"
Opportunity Entry."Salesperson Code" <-> "Salesperson_Purchaser"
Opportunity Entry."Campaign No." <-> "Campaign"
Opportunity Entry."Campaign No." <-> "Campaign Campaign Status"
Opportunity Entry."Opportunity No." <-> "Opportunity"
Opportunity Entry."Close Opportunity Code" <-> "Close Opportunity Code"
Opportunity Entry."Chances of Success %" <-> "Chances of Success _"
Opportunity Entry."Completed %" <-> "Completed _"
Opportunity Entry."Sales Cycle Code" <-> "Sales Cycle"
Opportunity Entry."Active" <-> "Opportunity Entry Active"
Opportunity Entry."Contact No." <-> "Contact"
Opportunity Entry."Entry No." <-> "SBU_Project"
Opportunity Entry."Entry No." <-> "Employee"


Virtual Cube
General Ledger
Member Cubes
G_L Entry
G_L Budget Entry
Customer Ledger
Member Cubes
Customer
Detailed Cust_ Ledg_ Entry
Vendor Ledger
Member Cubes
Vendor
Detailed Vendor Ledg_ Entry
Inventory
Member Cubes
Value Entry
Item Ledger Entry


Dimension
Gen_ Business Posting Group ("Gen. Business Posting Group")
Levels
Gen. Business Posting Group."Description"
Gen_ Product Posting Group ("Gen. Product Posting Group")
Levels
Gen. Product Posting Group."Description"
Source Code ("Source Code")

Levels
Source Code."Description"
Job ("Job")
Phase ("Phase")
Step ("Step")
Task ("Task")
Resource ("Resource")
Income_Balance ("Income_Balance")
G_L Account ("G/L Account")
Item ("Item")
Location ("Location")
Entry Type ("Entry Type")
Item Ledger Entry Type ("Item Ledger Entry Type")
Value Entry Entry Type ("Value Entry Entry Type")
G_L Budget Name ("G/L Budget Name")

Levels
G/L Budget Name."Description"
Customer ("Customer")
Customer Country ("Customer")
Foreign Keys
Table Country

Levels
Country."Name"
Customer."No."
Customer Territory ("Customer")
Foreign Keys
Table Territory

Levels
Territory."Name"
Customer."No."
Vendor ("Vendor")
Vendor Country ("Vendor")
Foreign Keys
Table Country

Levels
Country."Name"
Vendor."No."
Vendor Territory ("Vendor")
Foreign Keys
Table Territory

Levels
Territory."Name"
Vendor."No."
Salesperson_Purchaser ("Salesperson/Purchaser")

Levels
Salesperson/Purchaser."Name"
Campaign ("Campaign")

Levels
Campaign."Description"
Campaign Campaign Status ("Campaign")
Foreign Keys
Table Campaign Status

Levels
Campaign Status."Code"
Campaign."Description"
Opportunity ("Opportunity")

Levels
Opportunity."Description"
Sales Cycle ("Sales Cycle")

Levels
Sales Cycle."Description"
Sales Cycle Stage ("Sales Cycle Stage")

Levels
Sales Cycle Stage."Description"
Opportunity Entry Active ("Opportunity Entry Active")

Levels
Opportunity Entry."Active"
Contact ("Contact")
Inventory Posting Group ("Inventory Posting Group")

Levels
Inventory Posting Group."Description"
SBU_Project ("")
Employee ("")
G_L Entry Posting Date (Time)
Posting Date (Time)
Value Entry Posting Date (Time)
Estimated Close Date (Time)
Close Opportunity Code ("Opportunity Entry")
Chances of Success _ ("Opportunity Entry")
Completed _ ("Opportunity Entry")


Numbered List
Income_Balance
0 Income Statement
1 Balance Sheet
Entry Type
0 Purchase
1 Sale
2 Positive Adjmt.
3 Negative Adjmt.
4 Transfer
5 Consumption
6 Output
Item Ledger Entry Type
0 Purchase
1 Sale
2 Positive Adjmt.
3 Negative Adjmt.
4 Transfer
5 Consumption
6 Output
7
Value Entry Entry Type
0 Direct Cost
1 Revaluation
2 Rounding
3 Indirect Cost
4 Variance
Opportunity Entry Active
0 No
1 Yes

[/quote]