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.
Hi All,
I need some help to create mdx for the following scenario.
My source table is like this format
| FileName | AuditDate | FileType | FileStatus | AuditStatus |
| A | 20161102 | 20 | open | 0 |
| A | 20161101 | 20 | read | 1 |
| A | 20161031 | 20 | write | 0 |
| A | 20161030 | 20 | close | 1 |
| B | 20161102 | 40 | open | 1 |
| C | 20161101 | 45 | read | 1 |
| D | 20161031 | 40 | read | 1 |
| E | 20161031 | 20 | open | 0 |
| E | 20161102 | 40 | read | 1 |
| F | 20161102 | 45 | read | 1 |
When the user selects any Date in my application, Till selected date results are displayed for all filename.
My current MDX is
Is there any way of DeepSee support a hierarchical structure of grouping?
Example:
A product category structure:
- Code
- Name
- Group (parent)
Hi!
Sometimes you see that call to DeepSee cube building method:
w ##class(%DeepSee.Utils).%BuildCube("CubeName")does nothing.
Here are my 2 cents on possible reasons.
1. Run DeepSee Reset method in certain Namespace:
NAMESPACE> w ##class(%DeepSee.Utils).%Reset()
and try again.
2. Make sure, that all the indices in your base class for the cube are rebuilt, rebuild them and run it again:
w ##class(%DeepSee.Utils).%BuildCube("CubeName")Hope this will save some time for you, and will be helpful as was to me.
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:
1. Make sure that cube synchronization is possible in your scenario. See “When Cube Synchronization Is Possible,” earlier in this chapter.
NewBie's Corner Session 4 The Plus Sign and Concatenation Operators
Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.
Click on the Caché Cube in your system tray and select Terminal to try out the commands.
Plus Sign (+) operator
Typically, the Plus sign (+) adds two numbers together. This is true in COS (Caché ObjectScript), but COS uses it in other ways as well.
Set the variable X to a value of +12
Set the variable X to the value of +"ABC"
Hi,
Given a log file with these records representing, hypotethically, the ‘movements’ or changes in residential city, for citizens, like this: