Hi, I have a saved report setup with XFGets. One of the dimensions on
the report points to the member "Top." Is there a way to have the XFGet
show Top of the dimension and exclude a base member?Thanks.
I'm working on a cube view that displays reporting data in a quarterly
trend.The end user would select which quarter they want displayed and
the CV would display that quarter along with the 4 previous quarters.
Ex. User selects 2022Q1 and then CV dis...
This is my first time creating a book. I'm working on creating a book
that presents an income statement by location. The ideal outcome is that
the IS is displaying location at the top and each subsequent page
displays a child location member. I have ...
I'm working on a cube view that does a variance analysis between 2
difference scenarios. The scenarios will always vary based on the
scenario member selected by the user.Some of the rows use the formula
"GetDataCell" or a dynamic calc in the member f...
I've been creating cube views and have sometimes found that I may forget
to update a row that is part of a reporting segment. This results in the
sum of the rows not equaling the total row for the reporting
segment.Does anyone have any suggestions on...
Thanks for the recommendation on the alternate hierarchy. I will be skip
that since this is more like a one off request. I’m still new to XFGets.
How would you write a subtraction of an XFGet within the same cell to
exclude the base member?
Hi Peter, I took a look at the base members under the view dimension and
unfortunately they are not going to work the way I am going to need them
to. Since the CV I am making will display 5 quarters I will technically
need a trailing15monthaverage ba...
Hey, Following up on this. How would you write a formula to take the
average of the current quarter selected by the user + the prior 4
quarters? Thanks.