Can we include User Defined Functions in the Report Model

I have certain user defined functions in my database.

Can we include User Defined Functions in the Report Model.

Thank you,

Hi-

You can create custom expressions within a model using any combination of the supported semantic query functions in Model Designer. For example, you could create Employee.BirthWeek in a model by using the semantic query function Week(Employee.Birthday). The Employee.BirthWeek could then be consumed by reports through Report Builder.

However, you cannot create custom functions in code and reference them in a model. The underlying query translator would not be able to translate arbitrary code into T-SQL.

Hope that helps.

Thanks, Jon

Can we ask English Query to show a Graph ?

Hi
My EQ model dispalys a normal table when you ask a question such as;
show me the amount of goods solds for last 5 years.
it shows the amount grouped in to 5 years.
It would be nice if I can show it in a graph rather than the data.
I have seen a GRAPH verb in EQ but can't find a single help on how to make
it draw a graph.
Have anybody done this?
rgds
KK
Within English Query you can use something called commands which can run a
proc, shell out and run a batch file, etc.
Depending on your programming skill you should be able to use this to
generate a graph.
IIRC - Adam Blum (Not sure if I have his name correct), who is/was the PM
(Program Manager) for English Query did a demonstration at TechEd or PDC
where he demonstrated something similar.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"KK" <kk@.kk.com> wrote in message
news:uGyC1RiaEHA.2408@.tk2msftngp13.phx.gbl...
> Hi
> My EQ model dispalys a normal table when you ask a question such as;
> show me the amount of goods solds for last 5 years.
> it shows the amount grouped in to 5 years.
> It would be nice if I can show it in a graph rather than the data.
> I have seen a GRAPH verb in EQ but can't find a single help on how to make
> it draw a graph.
> Have anybody done this?
> rgds
> KK
>
|||Hi Hilary,
*Phew*
About time btw, thanks for the reply,
Well, coding is not at all a problem. I am already messing up with
the command object. can get smalll commands like sending
generated custom emails and such is possible...
however, trying to create relationship for graphs always
gives me errors (thats my bad) Do you have any idea
where I can find this guys demo ? link to a web page
where he might have information with a sample?
Amazing thing is, can't find a single help regarding this
on the web!!
I would greatly appreciate if you can send any links if u have
meanwhile, i'll dig for his name on the web
KK
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:ePN7tjnaEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Within English Query you can use something called commands which can run a
> proc, shell out and run a batch file, etc.
> Depending on your programming skill you should be able to use this to
> generate a graph.
> IIRC - Adam Blum (Not sure if I have his name correct), who is/was the PM
> (Program Manager) for English Query did a demonstration at TechEd or PDC
> where he demonstrated something similar.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "KK" <kk@.kk.com> wrote in message
> news:uGyC1RiaEHA.2408@.tk2msftngp13.phx.gbl...
make
>

can use Where in Dts query?

i create a model mining to know percent of product, which is like more by customer is have percent biger than other products that is don't like by customer.

i use DTS to get result to sql server.

select flattened

predict([modelName].[tablePredict],Include_statistic)

from

[modelName]

prediction join

.....

i have result with a table A in sql server:

productid $support ... $adjustedprobability

1 0.0 ...

1 0.0 ...

1 63.3 .....

how can i write in Dts so that table A not have record with value $support=0.0

- second: percent people like that product is knowned by $adjustedprobability or $support and value small or big

1:

SELECT FLATTENED
(SELECT * FROM Predict([modelName.tablePredict,INCLUDE_STATISTICS) WHERE $support > 0) as p
FROM [modelName]
PREDICTION JOIN ....

2: If you want descending, you can just use the column in the query - e.g.
SELECT FLATTENED Predict(model.table, 5, $AdjustedProbability) FROM ...

If you want bottom you need to use BottomCount(Predict(model.table),include_statistics), $support,5)

You should check my syntax - I just typed this from memory

Thx

|||

thank you very much.

you right when tell me check my syntax, there are some mistake.

thank you again

|||

hi, where can i put where in this query. it gives error when i try to use where clause.

i want 5 products but also their $AdjustedProbability should be > 0.36 ex.

SELECT FLATTENED

TopCount(Predict([Customer Products],

INCLUDE_STATISTICS) ,

$AdjustedProbability ,

5)

FROM [Basket Analysis]

NATURAL PREDICTION JOIN

( SELECT (

SELECT 'Product A' AS [Product]

)

AS [Customer Products] ) AS t

can use Where in Dts query?

i create a model mining to know percent of product, which is like more by customer is have percent biger than other products that is don't like by customer.

i use DTS to get result to sql server.

select flattened

predict([modelName].[tablePredict],Include_statistic)

from

[modelName]

prediction join

.....

i have result with a table A in sql server:

productid $support ... $adjustedprobability

1 0.0 ...

1 0.0 ...

1 63.3 .....

how can i write in Dts so that table A not have record with value $support=0.0

- second: percent people like that product is knowned by $adjustedprobability or $support and value small or big

1:

SELECT FLATTENED
(SELECT * FROM Predict([modelName.tablePredict,INCLUDE_STATISTICS) WHERE $support > 0) as p
FROM [modelName]
PREDICTION JOIN ....

2: If you want descending, you can just use the column in the query - e.g.
SELECT FLATTENED Predict(model.table, 5, $AdjustedProbability) FROM ...

If you want bottom you need to use BottomCount(Predict(model.table),include_statistics), $support,5)

You should check my syntax - I just typed this from memory

Thx

|||

thank you very much.

you right when tell me check my syntax, there are some mistake.

thank you again

|||

hi, where can i put where in this query. it gives error when i try to use where clause.

i want 5 products but also their $AdjustedProbability should be > 0.36 ex.

SELECTFLATTENED

TopCount(Predict([Customer Products],

INCLUDE_STATISTICS) ,

$AdjustedProbability ,

5)

FROM [Basket Analysis]

NATURALPREDICTIONJOIN

( SELECT (

SELECT 'Product A' AS [Product]

)

AS [Customer Products] ) AS t

Can ODBC be used in Report Builder or Report Model?

Dear All,

Our company use DB2.

When I download Report Builder from Report site or when I create Report Model project in VS, I can only use SQL Server Data Source.

Can Report Builder or Report Model use ODBC?

Thank U.

I am pretty certain that report models can only be built from SQL server or Analysis Services data source. Support for other data sources has been rumored to be on the way, but who knows. This was a major disappointment for our company.|||

You can use ODBC as a data source, but in a semi-roundabout way.

1. In SSAS, create a UDM (cube with multiple data sources) which points to your ODBC data source

2. Build an SSRS Model off the UDM/Cube (You must do so thru Report Manager, VS does not support building models from SSAS...only SQL)

3. Use the Model...

|||Not directly in this release. You can do it indirectly using SQL Server linked tables or by creating an Analysis Services cube first, then creating a report model on top of that.|||

Where can I find the steps necessary on how to use linked server tables when creating a report model?

Thank you.

Patti Biggs

|||

First, go to BOL and search on 'sp_addlinkedserver'. Then here are a couple of links to get you started.

http://www.sql-server-performance.com/linked_server.asp

http://www.databasejournal.com/features/mssql/article.php/3085211

R

Can ODBC be used in Report Builder or Report Model?

Dear All,

Our company use DB2.

When I download Report Builder from Report site or when I create Report Model project in VS, I can only use SQL Server Data Source.

Can Report Builder or Report Model use ODBC?

Thank U.

I am pretty certain that report models can only be built from SQL server or Analysis Services data source. Support for other data sources has been rumored to be on the way, but who knows. This was a major disappointment for our company.|||

You can use ODBC as a data source, but in a semi-roundabout way.

1. In SSAS, create a UDM (cube with multiple data sources) which points to your ODBC data source

2. Build an SSRS Model off the UDM/Cube (You must do so thru Report Manager, VS does not support building models from SSAS...only SQL)

3. Use the Model...

|||Not directly in this release. You can do it indirectly using SQL Server linked tables or by creating an Analysis Services cube first, then creating a report model on top of that.|||

Where can I find the steps necessary on how to use linked server tables when creating a report model?

Thank you.

Patti Biggs

|||

First, go to BOL and search on 'sp_addlinkedserver'. Then here are a couple of links to get you started.

http://www.sql-server-performance.com/linked_server.asp

http://www.databasejournal.com/features/mssql/article.php/3085211

R

Can not see Report Model Template in Business Intelligent Project Templates

Hi all,

I desperately need to setup the AD-HOC reporting on SQL server 2005.

I think one of the templates that I need is in Business Intelligent Project Templets Reporting Model Template in Visual Studio Templates.

But I do not see it in there.

Can some one please let me know where can I get the Reporting Model Template, or a link to where I can download or how to create it.

Thanks or any help.

Abrahim

You need SQL Server Enterprise Edition to deploy Report Builder functionality, and SQL Server Enterprise or Developer Edition to create the models. Installing that will give you the templates and other functionality needed.|||Thanks John!

Abrahim
|||Mark as answered, please. Thanks!