cancel
Showing results for 
Search instead for 
Did you mean: 

BPC Member Formulas - Internal Error .... no result set

ChristianSass
Participant
0 Kudos

Hi,

I would like to create a nested formula but whatever I try I get this error

Internal Error .... no result set

ENABLE_HANA_MDX = X

Any idea on that? I've cleared Dimension Cache already...

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Christian,

Did you check the ST22 dumps?
The problem appears in a classic or embedde environment?
To begin with, I suggest that you refer to the following note: 2218404 - Member Formula not working after activating HANA MDX.
I hope it will be helpful.

Best Regards,
Safa

former_member186338
Active Contributor
0 Kudos

Hi Christian,

"Nested formulas are only supported by the HANA MDX engine." - is it your case?

And why do you need nested formulas instead of simply repeat the formula?

Vadim

former_member186338
Active Contributor
0 Kudos

By the way, what is your BPC and BW versions/SP...

0 Kudos

Вадим, добрый день! Мы с коллегами пытаемся найти тут что нибудь, но безрезультатно.
Мы даже не смогли реализовать данную логику.

  • Hierarchy aggregation with formula results is supported:

         Hierarchy:
           A
            -- B ( = 10 )
            -- G ( = H * 3 )
            -- C
               -- D ( = 10 )
               -- E ( = F - 10 )
               -- F ( = 50 )
            -- H ( = 10 )

         Result:
           A: 150
           C: 100

Подскажите пожалуйста где можно найти подробное описание того как пользоваться MDX(описание функций, логики, может есть примеры)в MEMBER FORMULAS, системы консолидации BPС???

0 Kudos

Vadim, good afternoon! My colleagues and I are trying to find something thereabout MDX in MEMBER FORMULAS, but we can't.

We are not even able to implement this logic:

Hierarchy aggregation with formula results is supported:

          Hierarchy:

            A

             - B (= 10)

             - G (= H * 3)

             - C

                - D (= 10)

                - E (= F - 10)

                - F (= 50)

             - H (= 10)

          Result:

            A: 150

            C: 100

Please tell me where to find a detailed description of how to use the MDX (description of the functions of logic, may have examples) in MEMBER FORMULAS, consolidation of BPC system ???

former_member186338
Active Contributor
0 Kudos

"Hierarchy aggregation with formula results is supported:" - is not supported!

P.S. Please open a new discussion and clearly explain what do you want to achieve!