RE: [development-axapta] Business Views
Thanks Mike,
I guess there is not much hope for end users to get this except vai external
querying such as SQL or OLAP...
Thanks
James
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Savage
Sent: 26 April 2006 20:10
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Business Views
James
The way I have done that in the past is to write an actual SQL
statement, execute it and retrieve the record set and report on that.
Something like:
static void Job3(Args _args)
{
Connection con;
Statement statement;
ResultSet resultSet;
Str sqlSelect;
;
con = new Connection();
statement = con.createStatement();
sqlSelect = select DATEPART(yy,custinvoicetrans.invoicedate) as
Year,;
sqlSelect += itemId as Item, SUM(qty) as Qty ;
sqlSelect += from custinvoicetrans ;
sqlSelect += where dataareaid = 'DMO' ;
sqlSelect += GROUP BY DATEPART(yy,custinvoicetrans.invoicedate),
ItemId;
resultSet = statement.executeQuery(sqlSelect);
while (resultSet.next())
{
info(strfmt(%1 %2
%3,resultSet.getInt(1),resultSet.getString(2),resultSet.getReal(3)));
}
}
In the above example, it does limit the company, but, if you remove that
line, it will report across all companies.
You will then need to load the data to a temp table to allow you to use
Axapta's reporting, but that will do it.
The code should be executed within the report (obviously!)
Cheers
Mike Savage
Sense Enterprise Solutions Ltd
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of James Flavell
Sent: 26 April 2006 07:27
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Business Views
Hi Mike,
Yeah I am not too sure...I am guessing it was an early attempt at using
Axapta as some kind of BI tool as you have things like grouping but it
is
very limited and I get the feeling they did it and then left it because
it
was not worth anymore effort due to better tools being out there in the
BI
market
Anyway I am interested to know a little more on a somewhat related
issue:
Is it possible to have a report that prints data from all companies?
By default the kernel (I think) fitlers it to the current company so
even if
I cahnge the property 'Company' in the datasource it will only ever take
it
from the active company!!!
If there any way to avoid this behavior inside datasources/queries? So
far
the only possible way I have come across is by using business views but
these are not able to be used inside Axapta (because they basically
create
SQL objects)
Thanks
James
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Savage
Sent: 22 April 2006 00:43
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Business Views
Does anyone know what the purpose and use of the 'Business views'
functionality is in the Admin module?
According to the help text '_dictTable.name() != 'In the Business Views
form you create new business views allowing data from the database to be
wrapped and translated into human readable format.'
I can create a view in the form in Axapta and see it in the Views
section of Enterprise Manager, but now what? I could use another tool
to look at it I suppose, but how can I access it from Axapta?
Cheers
Mike Savage
Sense Enterprise Solutions Ltd
Corner House
Robey Close
Linby
Nottinghamshire
NG15 8AA
t: +44 (0) 115 964 6646
f: +44 (0) 115 964 6647
e: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
w: www.senseenterprisesolutions.co.uk
Confidentiality:
This e-mail and its attachments are intended for the above named only
and may be confidential. If they have come to you in error you must take
no action based on them, nor must you copy or show them to anyone;
please reply to this e-mail and highlight the error.
Security Warning:
Please note that this e-mail has been created in the knowledge that
Internet e-mail is not a 100% secure communications medium. We advise
that you understand and observe this lack of security when e-mailing us.
Viruses:
Although we have taken steps to ensure that this e-mail and attachments
are free from any virus, we advise that in keeping with good computing
practice the recipient should ensure they are actually virus free.
[Non-text portions of this message have been removed]
SPONSORED LINKS
Computer
http://groups.yahoo.com/gads?t=ms
http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=P
k=Computer+partw1=Computer+partw2=P
rogr
amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=y
Lpvc
LTIDJ5FTkRJGsO11w part Programming
http://groups.yahoo.com/gads?t=ms
http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+p
k=Programming+languagesw1=Computer+p
art
w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=9
0.s
ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft
http://groups.yahoo.com/gads?t
RE: [development-axapta] Business Views
James
The way I have done that in the past is to write an actual SQL
statement, execute it and retrieve the record set and report on that.
Something like:
static void Job3(Args _args)
{
Connection con;
Statement statement;
ResultSet resultSet;
Str sqlSelect;
;
con = new Connection();
statement = con.createStatement();
sqlSelect = select DATEPART(yy,custinvoicetrans.invoicedate) as
Year,;
sqlSelect += itemId as Item, SUM(qty) as Qty ;
sqlSelect += from custinvoicetrans ;
sqlSelect += where dataareaid = 'DMO' ;
sqlSelect += GROUP BY DATEPART(yy,custinvoicetrans.invoicedate),
ItemId;
resultSet = statement.executeQuery(sqlSelect);
while (resultSet.next())
{
info(strfmt(%1 %2
%3,resultSet.getInt(1),resultSet.getString(2),resultSet.getReal(3)));
}
}
In the above example, it does limit the company, but, if you remove that
line, it will report across all companies.
You will then need to load the data to a temp table to allow you to use
Axapta's reporting, but that will do it.
The code should be executed within the report (obviously!)
Cheers
Mike Savage
Sense Enterprise Solutions Ltd
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of James Flavell
Sent: 26 April 2006 07:27
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Business Views
Hi Mike,
Yeah I am not too sure...I am guessing it was an early attempt at using
Axapta as some kind of BI tool as you have things like grouping but it
is
very limited and I get the feeling they did it and then left it because
it
was not worth anymore effort due to better tools being out there in the
BI
market
Anyway I am interested to know a little more on a somewhat related
issue:
Is it possible to have a report that prints data from all companies?
By default the kernel (I think) fitlers it to the current company so
even if
I cahnge the property 'Company' in the datasource it will only ever take
it
from the active company!!!
If there any way to avoid this behavior inside datasources/queries? So
far
the only possible way I have come across is by using business views but
these are not able to be used inside Axapta (because they basically
create
SQL objects)
Thanks
James
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Savage
Sent: 22 April 2006 00:43
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Business Views
Does anyone know what the purpose and use of the 'Business views'
functionality is in the Admin module?
According to the help text '_dictTable.name() != 'In the Business Views
form you create new business views allowing data from the database to be
wrapped and translated into human readable format.'
I can create a view in the form in Axapta and see it in the Views
section of Enterprise Manager, but now what? I could use another tool
to look at it I suppose, but how can I access it from Axapta?
Cheers
Mike Savage
Sense Enterprise Solutions Ltd
Corner House
Robey Close
Linby
Nottinghamshire
NG15 8AA
t: +44 (0) 115 964 6646
f: +44 (0) 115 964 6647
e: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
w: www.senseenterprisesolutions.co.uk
Confidentiality:
This e-mail and its attachments are intended for the above named only
and may be confidential. If they have come to you in error you must take
no action based on them, nor must you copy or show them to anyone;
please reply to this e-mail and highlight the error.
Security Warning:
Please note that this e-mail has been created in the knowledge that
Internet e-mail is not a 100% secure communications medium. We advise
that you understand and observe this lack of security when e-mailing us.
Viruses:
Although we have taken steps to ensure that this e-mail and attachments
are free from any virus, we advise that in keeping with good computing
practice the recipient should ensure they are actually virus free.
[Non-text portions of this message have been removed]
SPONSORED LINKS
Computer
http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=P
rogr
amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=y
Lpvc
LTIDJ5FTkRJGsO11w part Programming
http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+p
art
w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=9
0.s
ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft
http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw
2=Pr
ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.si
g=yf
eG_U6QaLfPOZZIud02Fg axapta
Support
http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw
2=Pr
ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.si
g=hy
8yRGMzrmxdphyITTUeqA exchange
_
YAHOO! GROUPS LINKS
* Visit your group development-axapta
http://groups.yahoo.com/group/development-axapta on the web.
* To unsubscribe from this group
RE: [development-axapta] Business Views
Hi Mike, Yeah I am not too sure...I am guessing it was an early attempt at using Axapta as some kind of BI tool as you have things like grouping but it is very limited and I get the feeling they did it and then left it because it was not worth anymore effort due to better tools being out there in the BI market Anyway I am interested to know a little more on a somewhat related issue: Is it possible to have a report that prints data from all companies? By default the kernel (I think) fitlers it to the current company so even if I cahnge the property 'Company' in the datasource it will only ever take it from the active company!!! If there any way to avoid this behavior inside datasources/queries? So far the only possible way I have come across is by using business views but these are not able to be used inside Axapta (because they basically create SQL objects) Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Savage Sent: 22 April 2006 00:43 To: development-axapta@yahoogroups.com Subject: [development-axapta] Business Views Does anyone know what the purpose and use of the 'Business views' functionality is in the Admin module? According to the help text '_dictTable.name() != 'In the Business Views form you create new business views allowing data from the database to be wrapped and translated into human readable format.' I can create a view in the form in Axapta and see it in the Views section of Enterprise Manager, but now what? I could use another tool to look at it I suppose, but how can I access it from Axapta? Cheers Mike Savage Sense Enterprise Solutions Ltd Corner House Robey Close Linby Nottinghamshire NG15 8AA t: +44 (0) 115 964 6646 f: +44 (0) 115 964 6647 e: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] w: www.senseenterprisesolutions.co.uk Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Security Warning: Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. [Non-text portions of this message have been removed] SPONSORED LINKS Computer http://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Progr amming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvc LTIDJ5FTkRJGsO11w part Programming http://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+part w2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.s ig=cuhEClK4dU4wapXFmKisbQ languages Microsoft http://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yf eG_U6QaLfPOZZIud02Fg axapta Support http://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Pr ogramming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy 8yRGMzrmxdphyITTUeqA exchange _ YAHOO! GROUPS LINKS * Visit your group development-axapta http://groups.yahoo.com/group/development-axapta on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . _ [Non-text portions of this message have been removed] YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
