appreciate the support phil.   if anyone out there ends up in my shoes it sounds like the "Suite Scripts" team is the one you want for guidance.  I chose accounting...

• This reply was modified 1 year, 3 months ago by stan.

thx Brian and Phil.   If Netsuite's invoice etc API's can do this,  i would prefer to go that way.    I show a snippet below of their api list etc. ...

loaded question but i'll try.  for starters we plumb more than just pbi to cubes.  for example excel pivots.   i understand there is an extension to excel called power pivot...

not yet phil.   will look at it soon.

thx Perry and Phil.   Perry i'm not sure why you say vdi is better.  Phil, i dont see semantic models and ssas necessarily as alternatives.  i see them more as...

we are still having a problem down on the features where the singleton was originally interfering.   All features from all lines are showing up on all lines.  Below is an...

thx phil, i'm going to try to build on your structure to get those features.  I'll post results back here.

sure phil, this payload and query are representative.    we only get one set of features for each line number.

declare @xml xml=
'<root>
  <Header>
   ...

• This reply was modified 1 year, 3 months ago by stan. Reason: clarity

thx phil, i agree that pbi is super simple but the cost of ownership seems prohibitive.   Not to mention the lack of folder depth/organization in pbi.  by cost of ownership,...

i'm going to post a general question about using azure instead.   some hesitation but it seems like a way to address 2 challenges at the same time.   one of them...

thx chrissy i am assuming you are talking about this product and marking your post as an answer.    https://www.sqlbi.com/tools/tabular-editor/

probably log and email a ticket.  i (the bad cop) would start getting  the offenders to stop doing that slowly.

thx drew, admittedly passing 84 of anything between objects in sql is unusual.  not sure if thats object oriented or just absurd but thats why i mentioned that he doesnt...

• This reply was modified 1 year, 3 months ago by stan.

thx phil.   may not have that option as dba's etc will sometimes do what they want.  any thoughts on verifying automatically what is running was the last bim versioned?

Thx Brian, like you we believe that a func can return only 1 value or only one resultset.

also a proc cant return a table variable.

so are you suggesting that the...

• This reply was modified 1 year, 4 months ago by stan.