How to remove obsolete quantity from system model?
We recommend removing system model items manually in the application than using SQL. However you can use the below query to remove obsolete quantities from a system model. The obsolete quantity ID is needed. Each aggregate of a quantity has a separate ID. See the images below for an example.
SELECT
*
from
dbo.SecuredItem AS sec
JOIN dbo.ItemReference AS ir
ON sec.ItemID = ir.ItemID
where
ir.LinkID = '7d790e62-346e-4ba6-a9e4-8d7157ba0283'
Related Articles
Is there a way to remove active flags on attributes in system model?
The active flag is there because when tables are auto mapped to dimensions , the roles in the system model also bring in the active flags from the dimension table. There is no way to remove these active flags unless the user manually maps the views ...Unit of measure is mentioned for a quantity without a unit of measure in the system model?
The quantity itself does not have any unit of measure linked in the Setup Manager. See example below. Weight By Fact "BaseSales (FisCal)" is the reason "Cases" unit stays on "GrossSalesPrice". Any quantity that uses another for Weight By Fact will ..."Operation is not valid due to the current state of the object" error when generating the system model?
The exception is being thrown when invalid time expressions are in the system model for groups. Investigating Security yielded there was no entries for the admin group. Clear out the RLS expression table and regenerate the system model."An item with the same key has already been added" error when changing the name of a quantity in Setup Manager?
A quantity with the same name is hidden in the system model.Cannot remove Star from Constellation in Setup Manager?
There are several reasons for why a user is unable to remove a star from a constellation in the setup manager. Usually this is caused by some elements of the dimensions attributes or star quantities that you are trying to remove which are still ...