Skip to Content
0

Column headers for key and text

Dec 16, 2016 at 08:17 AM

771

avatar image
Former Member

Hi all

When displaying both key and text members, AfO only shows the column header in the first of the 2. Eg when looking at Key and Text for 0CUSTOMER, it just shows 'Customer' in the column header of the Key, and the column header of the Text is blank.

Does anyone know if it is possible to also show the column header of the Text column?

Reason: would like to use the AfO table as an input into pivot or powerpivot, as some functions are not yet available in AfO.

Thank you

Bart

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

3 Answers

avatar image
Former Member Dec 16, 2016 at 10:07 AM
1

Hi Bart,

I couldnt find any settings which offer to show the Description Column header! But when I used "Covert to Formula" option on the query...I got the below output.....Since you just want a pivot on it....it should be OK?!


afo-formatting.png (73.7 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Interesting option; I also tried a formula option to copy over but it doesn't stay when I pivot

1bart.jpg (148.6 kB)
0
Former Member
Tammy Powlas

Hmm....Just serached and worked out with that option for Pivot..

0
avatar image
Former Member Dec 16, 2016 at 12:29 PM
0

I went to BEx Query Designer and changed the name of the dimension as follows or description...

Then In Analysis for Office I loaded the query and did Convert to Formula...

Then created a pivot on it....

JP


query.png (72.4 kB)
pivot.png (41.6 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 16, 2016 at 01:42 PM
0

Thank you for your thoughts on my issue!

The challenge with converting to formula is that the data set is fixed. My need is that next time I refresh the AfO report, and my data set has grown, the pivot source adjusts accordingly, which I was hoping to be able to do as the AfO report has a named Excel table name.

Share
10 |10000 characters needed characters left characters exceeded