Data not included in cube build

[Sidney786]

Measure data not being included in build.

I have a sales and order cube which has 2 years data to date in it.

Consists of 11 dimensions and 6 measures of which 2 are sterling conversions.

The source data is via an IQD and I believe the conversion to sterling is being handled in the impromptu report.

This Cube is a daily build. Last working record was previous month.

Things tried:

Built cube saving as a fresh .mdc
Rebuilt categories
Saved as .mdl the opened and .pyi rebuild cube.

No changes have been made to the data that I am aware of.

Any suggestions?

 

[blom0344]

Did you try a Clean House on existing categories, rebuild relative times dimensions (if any) and custom categories (if any)
then save as .mdl , save as pyi and a rebuild of the cube?

Ties Blom

 

[drlex]

How does the current log compare to that from a time when it worked as expected?

soi là, soi carré

 

[Sidney786]

Thx for your answers.

I performed a clean house, re-gen categories etc.

I ended up removing the measures and re-inserting into the model, that seems to have fixed the issue.

 

[blom0344]

I actually had the same problem last year where no action seemed to prevail. Deleting objects and re-inserting them was the only solution. We are in the process of redefining our models in DMR for a number of reasons including the type of issues you were running into..

Ties Blom

 

[Sidney786]

Thx guys for all your suggestions