I have fact table with date_id column and date table with year, month, day columns. I can create a dimension with one dimension type. What influences the choice of the type? I dont see the diffence between this types in results.
What is diffrent between Time dimension And Standart dimension in Mondrian?
455 Views Asked by Nodon At
1
There are 1 best solutions below
Related Questions in OLAP
- OLAP Cube process error (A connection could not be made to the data source with the DataSourceID of 'Example_SQL', Name of 'ExampleSQL'.)
- Issues with deploying a project in SSAS: "Cannot deploy metadata"
- Why some of existing user not able to see newly added DB in clickhouse
- Filtering OLAP Pivot Table based on dates
- My SQL Server Analysis services won't switch from tabular to multidimensional
- Aggregating Members calculated with IIF / CurrentMember conditions
- markUsed is not marking segments as unUsed in druid
- How to add and backfill a column to a ClickHouse materialized vew and the underlying table
- Does TiDB Serverless support TiFlash for analytical jobs (OLAP) just like TiDB?
- Need to create a report in Apache Kylin using SSB sample data
- Excel CUBEMEMBER return multiple matches
- Calculated Member for Time Periods Hierarchy
- MDX get DISTINCT COUNT for Month to Date
- Relationship between dimension and measures
- Create Current Month
Related Questions in CUBE
- OLAP Cube process error (A connection could not be made to the data source with the DataSourceID of 'Example_SQL', Name of 'ExampleSQL'.)
- SSAS Cube Hierarchy Collapsing within Excel with sub values
- Trying to make a smooth dragging 3d box rotation
- SSAS cube aggregation formula when all dimensions' values are the same
- How to load the .cube file into the real-time iOS camera in swift iOS?
- Retrieving data from DataModel (Power Pivot) within VBA
- SSAS Process Cube error "We can't sign you in with this credential because your domain isn't available."
- Configuring TLS and SSL for AWS Fargate Cube.js Server with NLB
- Error while arming cube orange plus using ros2 which runs on a companion computer?
- cube animation in c++ with setconsolecursoreposiotion
- OLAP Query Cube Issues to config connection string for not login many times?
- Spark Connector with Cube js
- DAX - YoY Calculation don't work on higher Date level
- Process data: error: execution of DDL failed
- sync tabular model from single server to the two different servers at same time
Related Questions in MONDRIAN
- mondrian3 set by aggregate
- Can I take a velocity figure for a Fix Version in eazyBI JIRA App and use it calculate the velocity of a subset Fix Version? e.g. beta 1, beta 2, etc
- Mondrian schema - query to get number non null and null values from a level
- Pentaho ERROR: "every derived table must have alias"
- How to use Expressions in Measures in Schema Workbench?
- Pentaho mondrian cube main sql query
- Pentaho mondrian schema workbench on Macbook pro m1?
- using distinct count on mondrian, but still duplicate occur
- Sort measures where row and column axis are cross-joined in MDX
- Issue with relative date filtering Pentaho Workspace(Mondrian) AnalyzerDateFormat Week overlaps two Months only showing beginning days of the week
- Java Mondrian: How to DrillThrough in CalculatedMember ? Or set Zeroes instead of empty cells any other way
- Using MonetDB grouping sets with Pentaho Mondrian
- Aggregation last value and aggregation sum mdx mondrian
- OLAP cube designing: runtime generated measures
- OLAP level-based measure drilldown issue
Related Questions in ROLAP
- Create a report with an query
- Mondrian tries to optimize Segment.load weirdly resulting in partial or fully empty results
- Can any dimension be added to a SSAS CUBE dynamically
- SSAS ROLAP dimension isn't processed until manually browsed
- Query optimization beyond indexes
- MDX query to group on year of date dimension with specific date range
- Difference between CUBE and WITH CUBE
- Difference between a data warehouse and a MOLAP server
- Two Dimensional Database Design -SQL or JSON
- Mondrian with cassandra
- MDX query to sum measure of items containing dimension member
- Open Source OLAP Framework for Java?
- CUBE + outer join = extra NULL row
- Datawarehouse, ROLAP and Storage Space
- What is the difference between ROLAP and a Data warehouse?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You need to label a dimension as a time Dimension if you want to use time arithmetic functions such as
MTDorQTD: http://mondrian.pentaho.com/documentation/schema.php#Time_dimensions