Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Qlikview on star schema

Hi,

I want to know if there are best practices from the perspective of designing qlikview model on a data mart built at SQL Server.

Is it suggested to create an denormalized flat table at Qlikview?

Kindly provide feedback on it.

Thank you.

Sincerely,

Harshraj Sanghvi

Tags (2)
7 Replies
Highlighted
Contributor III

Re: Qlikview on star schema

Hi,

See this: http://community.qlik.com/docs/DOC-4556

Regards,

David

Highlighted

Re: Qlikview on star schema

Highlighted
MVP & Luminary
MVP & Luminary

Re: Qlikview on star schema

Hi,

Qlikview works better in Star Schema, because number of joined will be reduced during the runtime.

Regards,

Jagan.

Highlighted
Valued Contributor III

Re: Qlikview on star schema

In QlikView 11 for Developers we can see all the best practices in data model.

Highlighted
Honored Contributor III

Re: Qlikview on star schema

Highlighted
Contributor III

Re: Qlikview on star schema

Not always. Most of the times, yes, but not always. It depends on your data.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Qlikview on star schema

Hi,

Check this image for comparison between various schemas

Jagan.Untitled.png