Cube Views - Calling XFBR Rules w/in a XFBR Rule
Hi All,
I'm trying to call out a XFBR string w/in a XFBR string in the column set of my CV (snip below). Our consultant initially setup the first XFBR so that we could report on completed weeks of the month while rendering zero for the future weeks. The logic works great but is dependent on manually entered parameters. This is when I tried to introduce the second XFBR string to dynamically determine the prior week so that we can automate distribution of this output. After pushing in the second XFBR string I get an error when running the CV of, 'Input string was not in a correct format' (see second snip). I've tried to pass in the week value as an integer, a string, and as an Int32 value but nothing has worked yet. I've also tried with and without the brackets [ ] on the CV column set, but no luck. Any suggestions out there? Help would be greatly appreciated.
Thanks,
Bryan


