DEVELOPER CENTER
Hi All,
Does anyone have a database map available for writing questions on premium BI?
Database Map
Forum rules
- Check the documentation first. Before posting questions, please check the documentation to ensure it doesn't already cover what you need.
- No spam. All automated messages, advertisements, and links to competitor websites will be deleted immediately.
- Post in relevant sub-forums only. Messages posted in the wrong topic area will be removed and placed in the correct sub-forum by moderators.
- Respect other users. No flaming or abusing fellow forum members. Users who continue to post inflammatory, abusive comments will be deleted from the forum after two warnings are issued by moderators.
- Harassment. No threats or harassment of other users will be tolerated. Any instance of threatening or harassing behavior is grounds for deletion from the forums.
- Adult content. No profanity or pornography is allowed. Posts containing adult material will be deleted.
- Bandwidth. All images and signatures must be 500 x 500 pixels or smaller. Posts containing over-sized images and signatures will be removed.
- Illegal content. No re-posting of copyrighted materials or other illegal content is allowed. Any posts containing illegal content or copyrighted materials will be deleted.
-
FFsimprouser
- Posts: 19
- Joined: Tue Feb 15, 2022 1:57 pm
Re: Database Map
I've referred to this in the past, if of any help:
https://helpguide.simprogroup.com/Conte ... m%7C_____1
https://helpguide.simprogroup.com/Conte ... m%7C_____1
-
ciderapple
- Posts: 5
- Joined: Tue Oct 25, 2022 4:14 pm
Re: Database Map
The resource quoted on the help pages by jmc2408 is OK but a few typos are annoying. BI Premium does offer suggestions when typing but a diagram showing relationships on the help site would be really useful.
Doing select * from any of the tables doesnt help either in exploring column names as many of the column headings are aliassed in the output so the native query option is really parsed SQL rather than database access as far as I can make out.
Doing select * from any of the tables doesnt help either in exploring column names as many of the column headings are aliassed in the output so the native query option is really parsed SQL rather than database access as far as I can make out.