You’re offline. This is a read only version of the page.
Announcements
Hi,
I'm looking to get a single view or table that shows my Items in Business Central and the Dimensions each Item has been assigned. Any ideas how I can get this?
Thanks, Steve
Yes obviously you can do that in PowerBI without problems using OData for example (just need to publish a query object in NAV).
Hi Stefano, this looks great but we don't have anyone with AL skills here, unfortunately.
Any idea if I could do this with Power BI?
Thanks, Steve
You need to create an extension in VSCode with your DataItem (Item table and related Default Dimension table, where the relation is Table ID = 27 and "No." = your Item No.).
Then, in AL a report is defined like the following example (I've placed here a sample with 2 related tables):
When compiling, VSCode creates the layout (RDLC or Word) and you can modify them in Report Builder.
report 50100 MySalesOrder
{
//DefaultLayout = Word;
RDLCLayout = 'Layout\MySalesOrderReportRDLC.rdl';
WordLayout = 'Layout\MySalesOrderReportWord.docx';
UsageCategory = ReportsAndAnalysis;
ApplicationArea = All;
CaptionML = ITA = 'My Sales Order Report', ENU = 'My Sales Order Report';
dataset
{
dataitem("Sales Header"; "Sales Header")
{
column("No"; "No.")
{
}
dataitem("Sales Line";"Sales Line")
{
DataItemLink = "Document Type"=FIELD("Document Type"),"Document No."=FIELD("No.");
column(Type; Type)
{
}
}
}
}
/* requestpage
{
layout
{
area(content)
{
group(GroupName)
{
field(Name; SourceExpression)
{
}
}
}
}
actions
{
area(processing)
{
action(ActionName)
{
}
}
}
}
var
myInt: Integer; */
}
Hi Stefano, that's great thanks.
But I don't know how to 'create a report' in BC - can you help?
I see lots of standard looking reports in the Reports ribbon but I don't know how to create my own one. I'm missing something obvious, I think.
Thanks, Steve
This is exactly like in NAV. Check the Item table and then create a report based on Item and Default Dimension table for that item (there’s a 1:N table relation between these two tables)
#1
André Arnaud de Cal...
294,060
Super User 2025 Season 1
#2
Martin Dráb
232,858
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
