1

Topic: Removal of a part of the data from a cube

As it is possible to delete a part of the data from a cube.
The problem essence is simple:
Data is daily added in a cube, once a week special foreheads supervises correctness of loading. Sometimes, there is a failure of filling of the data. It is necessary to cut the data for a time interval and to flood anew.
I ask a pardon, but still while a teapot in cubes

2

Re: Removal of a part of the data from a cube

Mihich;
1) to adjust  (to add a condition) to delete from basis the data
2) to enumerate a cube (partition)

3

Re: Removal of a part of the data from a cube

So for this purpose it is necessary that there was all data in a DB for cube handling (((And at me only in a DB only operative (for days) (((

4

Re: Removal of a part of the data from a cube

I can find the data for a week, and here for years it already a problem (((

5

Re: Removal of a part of the data from a cube

Mihich wrote:

I can find the data for a week, and here for years it already a problem (((

Then saw DWH where will store the data for  to a cube.
It is theoretically possible to make cubed partitions on days and to flood the data in partition, but I do not advise.
You will have no place to take the data if you decide to change calculation formulas. And cube SSAS brakes at processing if partitions in it much.

6

Re: Removal of a part of the data from a cube

And unless it is impossible to make a copy of loading process and to feed to it the necessary date instead of SYSDATE or LOAD_DATE?

7

Re: Removal of a part of the data from a cube

Cubes were done not by me. I now support them. Therefore also there was a problem (idea) from a cube to cut the necessary window of the data, and then to flood in this window. That was not  the data. But I feel it is necessary to search in the data of a hole and to flood which that piece does not suffice ((

8

Re: Removal of a part of the data from a cube

Ferdipux, I ask a pardon, and DWH it that?

9

Re: Removal of a part of the data from a cube

Den Limonov wrote:

And unless it is impossible to make a copy of loading process and to feed to it the necessary date instead of SYSDATE or LOAD_DATE?

Yes and I do. But  each time manually to search for windows (((

10

Re: Removal of a part of the data from a cube

))))

11

Re: Removal of a part of the data from a cube

Mihich;
You  ate every day new partition, and in it  the fresh data  it is necessary to delete partition for the necessary day.
And how many now partitions at a cube (for the sake of interest)?
Data for measurements as changes?

12

Re: Removal of a part of the data from a cube

StarikNavy wrote:

Mihich;
You  ate every day new partition, and in it  the fresh data  it is necessary to delete partition for the necessary day.
And how many now partitions at a cube (for the sake of interest)?
Data for measurements as changes?

How to look how many partitions?
Data for measurements undertakes from sensors. Additional handling of measurements becomes.
: I while in it a teapot