Tag Info

New answers tagged

0

I think you are confusing things. First of all, processing the cube and processing the dimensions is sort of separate. I think you mean "processing the entire database". If you process only dimensions, and not the cube, the measures will never be updated. Also if you process dimensions, the cubes where the dimensions are linked will be in an "unprocessed" ...


2

As you noted in the comments for your other question your fact table data seems to be something like this: +------------+ + Sick leave + + + + Comp off + + Sick leave + + + +------------+ This kind of depends on your ETL loading procedures and reporting requirements. You essentially have 2 options Create separate measures To ...


1

It's hard to give you a specific guidance on your best setup, but in any case there is no such thing as a trigger writing to an OLAP cube. I can give you some starting points though. You need to look into different storage options for your cubes. By default cubes use MOLAP (Multidimensional OLAP) in which you process a cube on a scheduled basis[1] and ...



Top 50 recent answers are included