Date: Thu, 28 Mar 2024 17:47:30 -0600 (MDT) Message-ID: <465169327.2663.1711669650573@confluence-external-wiki> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_2662_407923244.1711669650572" ------=_Part_2662_407923244.1711669650572 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
To explore a basic introduction to creating views, visit the Creating a View page.
When building a view, you have several methods available to you, includi= ng;
From here you can proceed directly to the Report Builder.
From here you can proceed directly to the Report Builder.
Note: When writing an SQL view it is very important that you do =
not include an order by =E2=80=93 since results are sorted by the Java appl=
ication not the database. The order by will cause your view to fail.
Note:= When creating an OLAP cube as a view you will have limited opt= ions for updating field information. This is because most of the metadata i= s already contained in the cube itself.
The view builder for a composite view differs in that rather than displa= ying tables from a selected database it allows you to join existing Yellowf= in views together and create virtual tables from any defined database.
Note
We strongly recommend the use of Advanced Sub Queries over Composite = Views as the functionality is more flexible and robust.
Limitations