Hello,
I am trying to reference a dimension attribute on a spreadsheet and the formula doesn't come through.
=DBRA("r_best_practice",$A7,"Details")
A7 is the dimension element, the dimension is r_best_practice and the attribute is Details.
The formula doesn't return an error, just displays as blank in Excel. Can anyone help???
DBRA Forumla Issue - Perspectives using Slice
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: DBRA Forumla Issue - Perspectives using Slice
You seem to be missing the server name before the dimension name. It needs to be "ServerName:r_best_practice".youngjedi wrote:Hello,
I am trying to reference a dimension attribute on a spreadsheet and the formula doesn't come through.
=DBRA("r_best_practice",$A7,"Details")
A7 is the dimension element, the dimension is r_best_practice and the attribute is Details.
The formula doesn't return an error, just displays as blank in Excel. Can anyone help???
Works with both light sabres and blasters.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.