Home >Backend Development >Python Tutorial >处理cubes出现报错HierarchyError(\'Cut hierarchy %s for dimension %s is \'\'different than drilldown hierarchy %s. \'\'Can not determine implicit next level.\'% (hier, dim, cut_

处理cubes出现报错HierarchyError(\'Cut hierarchy %s for dimension %s is \'\'different than drilldown hierarchy %s. \'\'Can not determine implicit next level.\'% (hier, dim, cut_

WBOY
WBOYforward
2024-03-01 14:46:02887browse

处理cubes出现报错HierarchyError(\Cut hierarchy %s for dimension %s is \\different than drilldown hierarchy %s. \\Can not determine implicit next level.\% (hier, dim, cut_

The reason for the error

This error message indicates that when using the cubes library, the drilling level in the dimension is inconsistent with the sectioning level, so the next step cannot be determined. Implicit hierarchy of levels.

How to solve

To solve this problem, you should check whether the drill level and section level when using the cubes library are consistent. You may need to modify the drill level or slice level in your code, or add more information to determine the next implicit level. If you're not sure how to do this, consult the library's documentation or community discussions.

Usage Example

The following is an example showing how to use the cubes library for drilling and sectioning. In this example, we have a "sales" cube with a "date" dimension and a "product" dimension.

from cubes import Workspace

# Create a workspace
workspace = Workspace()

# ReGISter the "sales" cube
workspace.register_cube("sales")

# Create a new browser
browser = workspace.browser("sales")

# Drill down on the "date" dimension
browser.drilldown("date", ["year", "month"])

# Cut on the "product" dimension
browser.cut("product", "product_name", "Product A")

# PerfORM the query
result = browser.aggregate()

If in this example, the drilling level and the sectioning level on the dimension "date" are inconsistent, such as:

browser.drilldown("date", ["year"])
browser.cut("date", "month", "January")

Then you will get the above error message. Because the drill level is "year" and the slice level is "month". If you need to slice the data of a certain month, you need to drill down to the month level first.

The above is the detailed content of 处理cubes出现报错HierarchyError(\'Cut hierarchy %s for dimension %s is \'\'different than drilldown hierarchy %s. \'\'Can not determine implicit next level.\'% (hier, dim, cut_. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:lsjlt.com. If there is any infringement, please contact admin@php.cn delete