In Web Services, (1) I can only retrieve the pages (9305 and 143) but not the tables and most importantly, when comparing the pages (9305 and 143), they do not correspond to the tables. Then publish the query and use that.ġ) Following your feedback on the page inspector, the following holds true. The other method is to ask developer to create Query in BC for you that has all data. I believe SO Line has many to one relationship with SO header. In you case if SO Line has the majority of info then you can use it as main table and pull the data from other tables to it. But usually I try to pull the data such as Item info and Customer info from Master Card (Item/Customer) this way if any change happen on those cards my report is update by itself.Īlso, I usually use the table with most data as a main table and create a relationship with other tables. Then you can select more fields to publish. For sales page my recommendation is to select Create New from Existing. Then either decide to modify existing published web service or create a new one. If field is visible in page (you can see it in page or add it through personalization) then you can do the following : in Web Service page select Action->New Document -> Create Data Set. Page only included some "visible" fields. Sales Orders on Black Friday 2020 (November 27, 2021)Īssume all Sales Orders from Black Friday 2020 have been Posted to Invoice on varying dates (different posting dates / delivery dates)Īssume *some* Sales Orders from Black Friday 2021 remain unfulfilled (still a Sales Order) and some have been Posted to Invoice on varying dates ( different posting dates / delivery dates)įor Power BI you can only publish pages and not table. Sales Orders on Black Friday 2021 (November 26, 2021) vs. I wish to capture the Sales Order value (in $ or quantity or any other measure) by Date for reporting purposes.Į.g. Sales Orders are then fulfilled (delivered) at a later date at which time, once completed, the Sales Order is Posted to Invoice.įrom a BI point of view, I need to know the dollar amount and count of Sales Orders per date (whether still as Sales Order or Posted Invoice). Sales Orders from my e-commerce platform are paid in full at the moment of the transaction on the website. Question: How can Power BI query the value of all Sales Orders by Date (historically) for both Sales Orders that are open and for those that have been Posted to Invoice?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |