An OLAP cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications. An OLAP cube is a method of storing data in a multidimensional form, generally for reporting purposes. In OLAP cubes, data (measures) are categorized by dimensions
I’m working in a project for a Chile Police and I need to know if it’s possible to build a hierarchy in Deepsee like Zone- Prefecture – Comisaria – Destacamentos (there are 4 levels of police units) , but these information are only in one table that has the code, the father ,description and UnitType. (it’s recursive) . Example:
Hello, I've completed this tutorial: https://community.intersystems.com/post/deepsee-period-date-vs-same-peri... I've used the "year" level instead of a pivot variable. I want to calculate something like the following variation: 100 * ([DateOfSale].[PTD] - [DateOfSale].[LYPTD]) / [DateOfSale].[LYPTD] I create a new calculated member, under the same dimmension with the above expression. I put the new calculated member under the Count measure and it tells me that "Two measures cannot be crossjoined" What am I doing wrong? Can you redirect me to some explanations and maybe a solution? Thanks!
In DeepSee we have a field that is numeric but is used as a dimension. In DeepSee it sorts this field in the following order. 10, 11, 15, 2, 3, 5, 6, 8, 990. Is there a way to have DeepSee sort it numerically instead of treating it like a character field? We would want to see it show up in the dimension as 2,3,5,6,7,10,11,15,990.
I tried using the DeepSee Troubleshooting guide but the suggestions weren't working. Let's say that the source data we are using to build the cube on has a value out of range. This would cause the cube build/update to fail. How do I see the error log that explains which field has the value out of range? Please be detailed on exactly what command I should enter and where I should enter it in.
I assume that I go into a terminal session and to the correct namespace that we are building/updating the cube on, but the DeepSee Troubleshooting guide doesn't give that detail. I also tried the commands described in the Troubleshooting guide but I got syntax errors for almost every one.
I know per documentation (pasted below) to set the DSTIME parameters for the base class of a cube. If that base class has a property that is another class, do I have to add the DSTIME parameters to that secondary class?
Documentation says the following in a section titled "Enabling Cube Synchronization:"
Before you can synchronize a cube, you must enable the cube synchronization feature for that cube. To do so: