Generate Logical Star Using AI

Use AI guidance to quickly generate a customized logical star in a semantic model extension.

1. Navigate to the Semantic Model Extensions page, under Customizations Sandbox, hover over an applicable sandbox to view Actions, click Manage Sandbox, and then click View Sandbox.
2. On the selected sandbox Details page, click Perform Action, select Manage Logical Star, and then select Create Logical Star.
3. On the Logical Star page, click Auto Generate Logical Star.
4. Select schema and physical table, provide a fact table name to display in the Semantic Model, and then click Next.
5. Optional: Provide the business context for what the fact represents, such as SALES or FINANCE.
6. Review the list of suggested and selected entities after the columns in the fact are analyzed.
7. Click Select to include the entities you want and click Selected to remove any entities you want to exclude, and then click Next.
   The fact is analyzed further, and a list of suggested and selected dimensions is displayed for your review. The join column that'll be used to connect the fact to each dimension is also identified.
8. Click Select to include the dimensions you want and click Selected to remove any dimensions you want to exclude, and then click Next.
9. Review the selected dimensions and their join columns, then click Finish to generate the logical star.
   The generated star schema is fully editable and extensible. Refine or extend it as required.