Getting the value of a Table / Block Name

building reports webintelligence
1

Is there any way in BO XI R2 SP2 to return as a variable or formula the Table Name?

For example if I have 2 tables on the report 1 CrossTab and the other Vertical. They are named the same CrossTab and Vertical.

Under Properties → General → Name is there any way to return this value?
TableNameCrossTabVertical.jpg

joefonseca79 (BOB member since 2007-07-03)

2

I don’t think so, because there really isn’t anything that you can do with that information. What are you ultimately planning to do with the block name if you could get it?

Dave Rathbun :us: (BOB member since 2002-06-06)

3

I’m trying to supress blocks based on a DrillFilter selected.

I have a universe that returns values 1-4 for Dimension X.

I have a variable called Block.
=If ([I]=1;“Block1”;
If ([I]=2;“Block2”;
If ([I]=3;“Block3”;
If ([I]=4;“Block4”))))

Then a 2nd variable Block DrillFilter.
=DrillFilters([Block])

Then I setup an alerter like the following.

I need to say if Block1 is selected don’t show the rest of the blocks.
DF1.jpg
DF2.jpg

joefonseca79 (BOB member since 2007-07-03)