Skip to main content
Solved

Maximum cardinality exceeded error

  • August 19, 2022
  • 5 replies
  • 1390 views
nancy
Wallflower
Forum|alt.badge.img+2

Hi Team,

 

Could you please explain me about the error “Maximum Cardinality Exceed” and how can we resolve it?

 

thank you all in advance

Best answer by francois

Hi Nancy,
Without looking at your formula, it’s hard to say. Maybe your formula is trying to calculate on too many cells?
Have a look at this article that may help you or try avoiding to use densifying functions like ISBLANK.

Hope this helps!

    5 replies

    francois
    Employee
    Forum|alt.badge.img+13
    • francoisEmployee
    • Employee
    • Answer
    • August 19, 2022

    Hi Nancy,
    Without looking at your formula, it’s hard to say. Maybe your formula is trying to calculate on too many cells?
    Have a look at this article that may help you or try avoiding to use densifying functions like ISBLANK.

    Hope this helps!

    François (Pigment)
      Chahat
      Master Helper
      Forum|alt.badge.img+18
      • ChahatMaster Helper
      • Master Helper
      • October 3, 2024

      I am also facing the similar issue,
      Getting the error: “Maximum cardinality exceeded (3,460,343,100 > 1,000,000,000)”
      (IF(('Relocated?'),'Goal Value',0))
      If relocated is true, then return goal value, else 0.
      Source Metric and target metric are having dimensions: Employees, projects, integers 

      Can anyone please let me know how to resolve the cardinality issue?
       

      Issam Moalla
      Employee
      Forum|alt.badge.img+11

      Hi @pigment_enthusiast ,

      You can avoid the 0 in the second argument as it is not needed to set a second argument in the IF statement:
      IF('Relocated?','Goal Value'), this will result in blanks instead of zeros which will help you avoid the Maximum Cardinality error and take advantage of Pigment sparsity.
      here is the article as well to understand how pigment handles sparsity.

      Hope this helps 

        Chahat
        Master Helper
        Forum|alt.badge.img+18
        • ChahatMaster Helper
        • Master Helper
        • October 3, 2024

        It has resolved now, thanks @Issam Moalla .
         
        I have another metric wherein i have the formula, Getting cardinality issue.
        IF('Position' <> 1 AND (ISBLANK('Not Relocated?') OR ('Not Relocated?' = FALSE)),TRUE)
         

        I
        Apprentice Author
        Forum|alt.badge.img
        • IrenePApprentice Author
        • Apprentice Author
        • October 11, 2024

        Hi!

        I’m also facing the same issue: Maximum cardinality exceeded (96,303,838,267 > 1,000,000,000)

        'Total_Stats FTE'[filter:'SET_Include TBH Status in FC'][exclude:currentvalue=0] (pull from total stats fte metric to filter true values). I thought excluding 0 values would help but nothing’s changed. What might be the issue?

        Thanks. 

        Ask your question here!

        Terms & ConditionsAccessibility statement