Focal Point
[SOLVED] InfoAssist and 'OVER'

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1017089096

December 14, 2018, 09:16 AM
Doug
[SOLVED] InfoAssist and 'OVER'
Is the use of 'OVER' available from within out-of-the-box InfoAssist? Not by adding it in the Text Code. I don't see it here in FP or searching IA Help (http://MyStuff/ibi_help/index.jsp?scope=ia&topic=/com.ibi.help.ia/source/03_info30.htm).

Thanks, Doug
 

This message has been edited. Last edited by: Doug,




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
December 14, 2018, 09:18 AM
BabakNYC
Only for Measures. In InfoAssist if you go to the format tab and click Stack Measures, you get the OVER syntax.


WebFOCUS 8206, Unix, Windows
December 14, 2018, 09:20 AM
Doug
Dude... You're Awesome... That was too obvious and I overlooked it. Are you on the IB IA Dev Team?

This message has been edited. Last edited by: Doug,
December 14, 2018, 09:25 AM
BabakNYC
Not if I can help it. Smiler


WebFOCUS 8206, Unix, Windows
December 14, 2018, 09:30 AM
Doug
Smiler...

How about if I want something like this where I need two measures side-by-side over two more measures side-by-side over measures side-by-side over ...:
Sales Order Report       Current Week  Previous Week
Fully Shipped:	                   31            123
Partially Shipped:                 12             34
Not Shipped:                    4,567          4,567
Extended Sell Open:          $127,091       $127,068
Extended Sell Shipped:       $464,592       $364,235

Or, am I just asking for too much from IA?




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
December 14, 2018, 09:39 AM
BabakNYC
OVER syntax is very limited in InfoAssist so all signs point to no!


WebFOCUS 8206, Unix, Windows
December 14, 2018, 09:46 AM
Doug
Yeah, very limited, but understandable.

Rant: I get frustrated when others say that IA can do 'everything you need' or 'everything that AS can do'.

But, one of my mottoes is "A man has got to know his limitations" (and the limitations of the tools he uses).
Thanks, Doug

This message has been edited. Last edited by: Doug,
December 14, 2018, 09:48 AM
BabakNYC
Magnum Force!


WebFOCUS 8206, Unix, Windows
December 18, 2018, 10:32 AM
Doug
Thanks Again...
December 18, 2018, 10:56 AM
Tony A
quote:
How about if I want something like this where I need two measures side-by-side over two more measures side-by-side over measures side-by-side over ...:

Hi Doug,

In this instance I would consider the two weeks as the across element of your report.

T

BTW,
quote:
others say that IA can do 'everything you need' or 'everything that AS can do'
Where did you hear this?



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
December 26, 2018, 10:09 AM
Doug
It's a long story... Has anyone else come across similar claims by anyone?

Tony: More in PM.




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206