cube write back (committing)


    Sponsored Links


  • 1. duplicate dimensions
    Hi, I'm a MDX newbie, but I'd appreciate some help. Here's my basic query, SELECT [Source].[Vch Source].members ON ROWS, [month].members ON COLUMNS FROM [Sessions] WHERE ([Source Type].[x Source Type].[Search Engine], [year].[2003]) but it gives me. duplicate dimensions across (independent) axes - when calculating a query axis Do I have to create another time dimension on my cube, or is there a way to just limit the year in MDX. Thanks for you assistance. Ephraim.
  • 2. OLE error 800A00CE
    Hi. What does this error mean? I started to receive it a couple of days ago while I am trying to incrementally build some cube using my own application through DSO. The few other cubes are successfully updated using the same routine as problematic one. Moreover, the routine works well for a couple of years - only one is changed is database grow up a bit. The query used to build an incremental partitition returns result immediately - the whole recordset is returned in a couple of seconds. And I am able to incrementally update this cube using MMC... but could not do it using my own application. Can anybody help me?
  • 3. AS2000: important questions
    Hi guys! First of all: I from Austria so excuse my bad english! I still workin on an OLAP project since 3 month! During this time I found some important questions but no answers. These are as follows: 1. In the Dimension-Editor the property "member count" is only set during the creation of the dimension and not during the preparing-process (is this the english expression?) What for do I need this property? Only for erstimation-values during the preparing-process? 2. Is there a way to pass over "ring-connections" in the cube-editor? 3. How can I include one dimension two times in a cube connected to different forein keys in the fact-table? 4. I have only one Cube with a lot of dimensions. Is it better to make this dimenions private or public? 5. When du the creation of the aggregations occur? During the memory-administration (in german "Speicheraufbereitung") or during the preparation of the cube? The second one I guess!? 6. I have to do the memory-administration only one time! Is this correct? 7. The database for the dimension is growing every time and the preparation works automatically. What happens when member-count exceed the limit of 64000 members? thx in advance!! D. terreicher
    Please use the english language to communicate, since many people probably do not understand turkish - if it is turkish - including me. Lutz
  • 5. Transfer Techniques.
    When I am transferring lets say a 'Product Class' table from the production servers to the data warehouse. is it better practice to always delete the current product classes in the table and then re add the ones from production servers? Or, would it be better to look for the changes between production and data warehouse and only add or update those that need to be? It seems that it is easier to just delete all the records in Product Class and then re-add but what about over all efficiency of the SQL server pertaining particularly to storage abilities. (Page splits, heaps and stuff like that). Since product class generally seems to be a small table would you use the same method for say a customer table which for us contains upwards of 7000 records. To me, it just seems to delete and re-add these on a nightly basis would almost cause SQL fragmentation if you will. Any thoughts on this. -mike

cube write back (committing)

Postby QXZp » Wed, 13 Sep 2006 07:03:03 GMT

Is there a limitation on AS2K cube write backs if the connection is over 

If not, does anyone have any tips for getting it to work?

Using Proclarity Desktop 5.3 or 6.1
Cube Server: Win 2003, AS2K 32 bit, SP4 w/ SQL Server 2000 SP4 DB.
User has full read access to the cube. Cell security shows unrestricted read 
and write.


Similar Threads:

1.How to Write back to OLAP cube from Excel


Is it possible to write back to an OLAP cube/data table from Excel?
Sorry if the question is obvious. I am from Essbase background trying to
learn SQL AS.

I would appreciate very much if somebody can point me some links on this

Many thanks in advance.


2.Urgent: Recursive write back on a cube


I am calculating profit for sales cube by variating the measures store
cost and store sales. I want to give a variation range for both the
input parameters for example store cost may vary upto 100% from the
origional store cost in order to simulate the profit for the given
input values.

One way that i figured out is to write the values temporarily on cube
and than query for the profit. It seems to be inefficient way to write
back hundred times and retrieve data 100 times if i want values for
every 1 % change.

Is there a way arround by which i can simulate this or give a range of
values to some function to do this or write multiple values for the
same measure.

3.write back 2000 virtual cube

think i had this working at some point.

running 2000 sql server sp4

but now i get an error

unable to open cellset
unable to update n/a cell in the virual cube

As i recall the last time i had to install sp4 all over to solve it but do i
need that all the time then ?

4.Requirements for writing back measures to a cube from Excel 2002

What are the requirements to write a measure via Excel 2002 to a cube?

I have done the following:

1. Enabled writeback on the cube.
2. Used example code from "Extending OLAP" on MSDN in the workbook.
3. The cube was created using SSABI.

Here are the references enabled in the spreadsheet:

Visual Basic for Applications
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library
Microsoft ActiveX Data Objects 2.8

Excel never returns from executing the update cube statement to a local or
remote cube.

Any suggestions will be greatly appreciated.



5.How to Write back to OLAP cube from Excel

6. Write Backs to Cubes in Reporting Services

7. Write-Back : how to enable write-back on a cube?

8. Transactions Roll Back and Commit



Who is online

Users browsing this forum: No registered users and 6 guest