wher to find my +column tab and layout tab in design mode

[sunilyoganna]

Hi all

i am using Dynamic AI personal Edition but i cant find my +Columns and lay out tab in my design window
please help me out i am new to Dynamic Ai an in my auto preview section i am not able see the SQL Radio button please help me out.

Thanks and Regard's
SunilYoganna

[Carsten Sørensen]

Hi,

The +Columns should be available on the list tab (in older versions you are right that they had an own tab).

The Layout tab - available on IE only for the time being - is hidden if "Form (floating layout)" - is selected on the General tab. If you are using IE and "Drill-down to" is set to "Form" then the Layout tab should appear.

The SQL option (to be able to see generated SQL) is available in the Server and Enterprise editions only.

Best regards,
Carsten

[sunilyoganna]

Thanks Carsteon,

for your information and i have one more question regardin connecting of Excel Data Base
i have Excel File By Name Book2.Xls
When I test the connection it Througing Exception Could not found Book2.Xls
i am using personal Edition please find me a Solution

Thanks & Regar'd
Sunil Yoganna

[Carsten Sørensen]

You need to specify the full path to the Excel file. E.g.: C:\yourdata\Book2.xls then it should work.

regards
Carsten

[sunilyoganna]

thanks Carsten,

if the is given correct it shows connection is successfull but when i browse through the table it shows no data found what i have to do know carsten.

Thanks Regard's
Sunil Yoganna

[Carsten Sørensen]

Sorry I misunderstood your question!

You need to define named Data-ranges in the Excel Sheet - that Dynamic AI can use as Data-sources, i.e. The range must have column headers and each row in the table will be 1 record in Dynamic AI. The ranges should then appear as a table source in Dynamic AI database explorer.

Be aware that you sometimes are not allowed to have the sheet open at the same time as using the file from Dynamic AI.

Best regards,
Carsten

[sunilyoganna]

Hi Carsten,
Thanks for your usefull inormation my problem got solved and now only proble is when i browse the table Excel Sheet name is also coming only when i use .xlsx format i.e when i select Excel Spread sheet 2007 if i use .xls it works fine. What i have to do to avoid Excel sheet name, because when i click on the Exel Sheet name it showing Syntax error in FROM clause

Thanks and Regard's

Sunil Yoganna

[Carsten Sørensen]

Hi Sunil,

I'm not sure I understand exactly - but usually we define "reports" - eventually just a simple table report to place the relevant data-ranges in the Report menu for browsing, report creation, investigations, Automated Intelligence etc. I.e. It might be that the database explorer will expose some ranges (the ones that you see as sheet names) that are not suited for use as a data-source...

Don't know whether you have already seen this but there are some documentation available at:

viewtopic.php?f=8&t=114

viewtopic.php?f=8&t=113

Best regards,
Carsten

[sunilyoganna]

Thank you Carsten,