TM1 Forum

blackhawk - Thank you! Sounds great and less painful :), I do like that concept, as it is still easier for me to implement via sql then via ti scripting... I will try that in a few days... Fortunately for us, we only have single parent hierarchies (multi-parents hierarchies are probably a bit more p...

Thank you for your suggestions. We ended up building a cube with SCD for all dimensions, except the one with a hierarchy (Party dim). I will need to remodel it later on... The difficulty was -- we are reporting off ~50k parties each day (and out of ~50k only 200-300 names are changed daily), so sett...

Thank you, so much for your replies! I am really after figuring out how to best model the cube, dimensions, etc for this particular case... I am trying to twist my brain a bit, to think in the OLAP terms... Here is my question: If I drop the Partition Key from the Reference data tables, like Party, ...

Here is our schema sample. Thanks, Ann

rkaif, tomok, Thank you for your suggestions. It actually helped me to understand what I am really after much better. It's a bit confusing, but here is our db setup. Each day a new partition is created for the full stack of data available on that day. Partitions in our case represent a version of th...

Hello Experts, I have a challenging task, that is to build a historical cube off relational data model, which is partitioned by a date, so each day we have a new set of data in all reference and fact tables. In reality, no one would ever aggregate the data across multiple dates, but the user might n...

DB Environment: Oracle 11G TM1 v. 9.5 on Windows Question: How to create a Cube based on existing cubes by selecting all data from one cube and the latest corresponding values from another(I will have to find the latest corresponding value for each row of data, not for the whole set)? I have a fact ...