Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

ReportBuilder - Cell range via Excel named area

Avatar

Level 3

Hello,

in ReportBuilder, we want to pull data for all our Site Channels (eVar), so I created a named cell range "Sitechannels" with the Excel name manager and specified the lookup in ARB as "Specific / from range of cells" with the range "=Sitechannels".

I now updated the list of Site Channels and realized that the ARB did not update, as ARB "converted" my name range back to an absolut cell range, e.g. A1:45. So I have to update all requests (>30) with this lookup manually.

The expection is to make use of the Excel name function, so all updates of a lookup range will also be reflected in the ARB requests.

Is this "as designed" or another ARB bug?

 

BR

Hans

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi Hans,

 

I believe it is working as designed. You have to refresh manually. OR you can use the function listed in this doc : 

http://microsite.omniture.com/t2/help/en_US/arb/invoke_arb_excel_function.html

I think if you use the functions you will be to obtain what you need have fun.

 

Best regards.

 

Alexis Cazes

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi Hans,

 

I believe it is working as designed. You have to refresh manually. OR you can use the function listed in this doc : 

http://microsite.omniture.com/t2/help/en_US/arb/invoke_arb_excel_function.html

I think if you use the functions you will be to obtain what you need have fun.

 

Best regards.

 

Alexis Cazes