question

Comanchi-1008 avatar image
0 Votes"
Comanchi-1008 asked ZoeHui-MSFT commented

Detail level measure not working

Hi All,
I have a FACT and a dimension , in the SQL Server database when i do a join and run the query, it show me sales amount per each item, but in my CUBE browser, when i bring in the item and sales amount, it displays all items, but the sales amount is showing as sum of all the items. please need help.
Thanks

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @Comanchi-1008,

Thanks for posting here. Regarding your question, the reason that you will get the sum of all the items is the relationship between Fact and Dimension has not been create, please go back to your SSAS project and set the relationship for these two tables.

create-a-relationship-between-two-tables-ssas-tabular

If you are using SSAS multidimensional mode, please refer to below document to create relationship.

lesson-5-defining-relationships-between-dimensions-and-measure-groups

Regards,

Zoe


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·