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
BedrockMission!

Learn More

View all

Sign in to view all badges

ReportBuilder - Cell range via Excel named area

Avatar

Avatar
Validate 1
Level 3
emilius22
Level 3

Likes

25 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
emilius22
Level 3

Likes

25 likes

Total Posts

25 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
emilius22
Level 3

15-10-2015

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
AlexisCazes
MVP

Likes

186 likes

Total Posts

422 posts

Correct Reply

198 solutions
Top badges earned
Contributor
Shape 1
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Contributor
MVP
AlexisCazes
MVP

Likes

186 likes

Total Posts

422 posts

Correct Reply

198 solutions
Top badges earned
Contributor
Shape 1
Give Back 10
Give Back 5
Give Back 3
View profile
AlexisCazes
MVP

15-10-2015

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

Answers (0)