Hello,
We have attached a pivot table in Excel 2007 to our database.
In Excel I have then converted the pivot table to formulas so that I can build a report and then have the system fill the report in.
I have a simple report looking at revenue and an Example of the formula being used is:
CUBEVALUE("\nltdb MatrixCubes MatrixCube",$A$1,$B3,$A$5)
Where $A$5 is referring to is a dept name referred to in the formula as:
=CUBEMEMBER("\nltdb MatrixCubes MatrixCube2","[Job].[By Booking Office].[Booking Office].&[Stg Ltd. UK].&[Green Team]","Green Team")
But what you see in Excel is Green Team
If I copy and paste special values this field the first formula still returns the revenue value, however if I type in Green Team it returns an #N/A
Any ideas why it would do this and how to rectify the problem?
Thanks
Bookmarks