Skip to Content
0

How to remove the dependency between a restricted key figure and a text variable

Feb 09 at 09:30 AM

71

avatar image

Hi Team,

We created a restricted key figure and in description gave a replacement path text variable.

Now we don't want to use that text variable, so we removed it from the description of the key figure. But every time we execute the query, system comes with message : could not find value for the text variable.

I HANA studio, when we checked the restricted key figure, in the dependency tab, the restricted key figure is shown to be linked to the text variable.

How do we remove this link. Please suggest.

Thanks!!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Selva AM Feb 09 at 04:12 PM
0

Hi Shubham,

Did you run the Bex query in RSRT or in AO? Do you still the error or warning message?

-- Selva.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Selva,

I ran the query both in AO as well as in RSRT. Both ways, I am getting the same error that could not find value for the text variable.

When we open the keyfigure in HANA studio, the dependency tab somehow shows the link between the keyfigure and text variable. Somehow if I am able to delete this dependency, then this issue will also resolve. Problem is, I am not able to delete this dependency as I can see no where key figure and text variable to be linked.

Regards,
SHUBHAM

0

Hi Shubham,

What is the version of BW you are using?

-- Selva.

0
Cornelia Lezoch Feb 12 at 10:27 AM
0

Hi Shubham,

go to transaction RSRT and regenerate the query.

regards

Cornelia

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Cornelia,

I ran the query using RSRT multiple times. Still I am getting the same error.

Regards,
SHUBHAM

0

did you only execute? Or generate?

if generation does not help, check what happens when you collect the query for transport - is the variable included in the collection?

If yes - it ist still used in your query.

check all used global key figures, check different languages

regards

Cornelia

generate.jpg (151.9 kB)
0