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_
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.
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.
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!