Views And Report Models
Apr 16, 2007
Need a little help here. I would like to utilize the ad-hoc capabilities of Reporting Services to grant the users of one of my web apps the ability to create all sorts of crazy reports that I don't have to develop.
Basically, this web app is a flexible survey engine. My vision is to have the users select questions from a survey that they wish to generate statistics on. My application would create a view in the database that transposes the data into a tabular format. They would then get kicked over to the reporting services web client, where they can regenerate a report model, and then fire up report builder to create their crazy statiscal abomination. (Aren't users grand!)
This process sounds wonderful, but I'm not aware of any way to get the report model to regenerate and pickup any views. I can get it to pick up any new tables that are added as long as a primary key is created for them, but I want the automated dynamic data rendering that comes with a view. Hopefully, some of you out there have tried to do this already and have some ideas that may help me. Thanks!
View 2 Replies
ADVERTISEMENT
Jul 18, 2007
Hi,
Is anyone using Report Builder via a Report Model generated from Analysis Services in production?
From what I have seen on the Forum people have done this from books, but it is not clear as to whether they have used it at work, in production. There do appear to be reports of some problems with the integration between the two, and with performance.
The attraction of Report Builder on top of Analysis Services is that we should only need to define measures, security, etc, once in the Cube, not twice, as we would if we had to use Report Builder on top of a relational source, alongside Cubes on Analysis Services.
What I would like to find out is:
1) If there is someone who has deployed Report Builder on top of both a relational data source and Analysis Services. If so, which has been taken up best by the users?
2) How does the navigation in Report Builder work with Cubes. It seems a little bizarre in that you can only drill down, never up. Is there any way around this. Do you need to design the Cube specifically to support the Report Model? If so how?
3) The generation of the report model is easy. However, is there any way to control this, or to edit it later?
4) We have had problems with Report Models on relational sources where changes have invalidated the Report Model and all reports built on it. Can similar problems arise, for example, if you change the Cube and then Re-Generate the Report Model?
5) Are there any other issues around Report Builder. The two I have found so far seem to be Hidden Dimensions showing up, and Report Builder not working if measures are defined as non-aggregatable.
6) Are there any other end-user adhoc reporting products which work better with Analysis Services?
Regards
Paul
View 4 Replies
View Related
Jun 6, 2007
I have a Sharepoint integrated Reporting Services server. I have created Report models based on Data Sources. I then created Report Builder Reports to make some BI Charts and Graphs. They look great and work fine for a few days then all of a sudden I get a rsItemNotFound error saying it cannot find the Report Model which is clearly there.
An error has occurred during report processing. (rsProcessingAborted)
The item 'IT Reports/PWPDB_Prod_Model.smdl' cannot be found. (rsItemNotFound)
If I open the Report Model from Report Builder it loads the data fields, but also fails to run reports with the same error
If I try to regenerate the model from the library I get an error stating that the model needs to be a generated model.
The model specified must be a generated model.
(rsModelNotGenerated)
Even after rebooting all of the servers in the farm I get the same messages. I can regenerate a model from the data source and it doesn't work. I am seeing no errors in the logs of my app server at all regarding reporting services.
It looks as though I will have to de-integrate Reporting Services as it is not viable for a business critical application.
View 8 Replies
View Related
Apr 8, 2007
Hi,
the database my app is using contains information from multiple user organisations, a sort of multi organisation database. I intend using the reprot builder to provide access to a user ine ach organisation. However the issue of who sees what info has popped up and i'm trying to think of a way to restict the user of report builder to only be able to see their own organisations information. This is a social services type application which is used by mutlitple service providers so organisations get twitchy about other organisations being able to see detailed client info. on the application the security stops this but at am a t a loss as to how to best restirct access to an organisation won client data.
any thoughts? is this somehting that can be configured through the reprt model and the report builder user account?
few ideas or advise would eb v helpful,
trhanks
View 4 Replies
View Related
May 29, 2007
I am having a problem deploying or manually uploading smdl files to reporting services. I can upload anyother type of file without a problem. (dsv, ds, etc.) However, when i try to upload a smdl file, I get
"The permissions granted to user '<me>' are insufficient for performing this operation. (rsAccessDenied)"
How do I fix this?
Thank you"
View 2 Replies
View Related
Apr 17, 2007
I am have a few reports built in Report Builder and obviously using Report Models. All these report models are using a share data source. When I try enable to enable chache or creating subscription I get and error that "Credentials used not stored".
I thought well let me store the credentials for the data source used by the model used by the report on the server. I still get the same error.
I tried to create a custom data source for the report but there is not option for connection string to connect to Report Server Model. We have "Microsoft SQL SEVER", "OLE DB", "Microsoft SQL Analysis Services", "ORACLE", "ODBC", "XML", "SQP Netweaver BI" and "Hyperion Essabe"
if I understand this right to create cache or subscription I must store the credentials for each report making shared Data source concept redundant. Also I cannot create a connection string to connect to Report Server Model.
I would greatly appreciate if anyone can tell me how to enable cache or subscriptions for report that are built on report models using shared data source.
View 1 Replies
View Related
Apr 30, 2007
How does the report model know what data source view to use? I could not find it defined anywhere in the .smdl file.
My problem is this. I have a Report Model project with two data sources, two data source views and multiple report models. When I try and bind a data source to an entity in the report model I do not get to choose which data source view to use to choose what table/view I want to bind the entity too and only the tables in one of my DSV's shows up. When I first created it, it worked fine. It automatically selected the correct view and table and was successfully created but now when I open the project, that correlation is lost.
Any suggestions or help is appreciated, thanks.
View 1 Replies
View Related
Apr 30, 2007
Hello,
When I open Report Builder I do not see any of the models that I've created. The "Select Site or Server" is blank and I cannot get to any of the models. I can't change the dropdown from "Recent Sites and Servers."
I am not sure what I did, because it used to work. I did install SP2 but that did not cause a problem originally.
I can create new models (on both the BIDS and the ReportServer site) and I see that they were created just not in Report Builder. At this point Report Builder is non-functional for me.
The other thing that may be related is that I've never been able to run Report Builder from the website. When I click the button nothing happens. I made a shortcut to ReportBuilder.exe to get around this.
Thank you for the help.
-Gumbatman
View 2 Replies
View Related
Apr 11, 2007
I am having mucho difficulties deploying Report Models from my box.
I create a brand new report model project, I add a data source, a datasource view, and a report model. Everything builds fine. I setup the project to point to a valid SSRS Server (and I tried this on another person's box, everything worked fine), click deploy- enter the credentials, and the logon box just keeps popping back up instead of deploying.
When the credential box pops up, it has a "" in it. When I try this on another person's box, it works fine.
I just upgraded to SQL Server 2005 SP2, but I do not have Visual Studio 2005 SP1.
Could some of that be a problem?
View 1 Replies
View Related
Apr 16, 2007
I never got an answer on this so I am reposting this issue. Also, please note that I have consistently reproduced this issue on multiple perspectives within and accross multiple cubes on 3 different SQL Server Instances. I have also had no problem with perspectives within Report Models that were not generated from an SSAS Cube.
Specifics:
=========
I have created a simple cube in BI Studio against an Oracle Relational Data Warehouse. In this cube I have created a perspective in which I have selected (included) only a small subset of measures and dimension. When I view this perspective on the Browse Tab of BI Studio, only the entities that were included in the perspective were available for report construction as was expected.
Next, I generated a model for this cube in Report Manager. Now here is the problem, I then opended the model in Report Builder and selected the same perspective from above, but all of the Entities in the cube were displayed including the fields I explicitely did not include in the perspective. I then looked at the .smdl file describing the Model and it looked like in the Perspective description section all of the cube's entities were included, even the ones that should not have been included. It seems as if the problem is ocurring durring the model generation. I also tried generating the model in Management Studio and it seems to be doing the same thing.
Any ideas on how to fix this? Could I be doing something wrong(probably)? I have to give a presentation soon and this is a big deal for the Project Stakeholders.
By the way, I am using the 180 Day Evaluation of Sql Server 2005 with SP2 CTP installed.
View 1 Replies
View Related
Jan 3, 2008
hi,
I am new to SSRS. I am doing some report models for Ad-hoc reports. Im my database i have some users and their roles according to my requirement. User should only see the particular reports if he have privilege. how to customize...
User will access Report Builder to do adhoc report.
For example
I have 5 report Models
rptModel1
rptModel2
rptModel3
rptModel4
rptModel5
In my data base there are 3 users.
user1 have privilege to view rptModel1, rptModel3
user2 have privilege to view rptModel4, rptModel5
user3 have privilege to view rptModel2, rptModel5
When Particular user access the report builder, There i want to show only that particular Report models...
is there any posibilities to do this please Help me.
Thanks in Advance...
-Kannan
kannan1017@gmail.com
View 5 Replies
View Related
Oct 19, 2007
Hello Everyone,
I'm just trying something that I haven't tried before, and I'm wondering if anyone has done it before. I'm building a report with three charts. This chart is going to go inside of Microsoft CRM. One of the charts has to use CRM filtered views, so that a manager can see his whole team's numbers, but a team member will only see his numbers. I can't do this any other way because of the complexity of the query, which has 3 select statements joined together as tables. It would be too complex to try to use a parameter throughout all of those tables, and I'm not sure how I would set up a parameter to show all of the data if the user were the manager, and only the single user's data if it were someone else.
The other two charts use filtered views as well, but they have similar joins, and I had to hard code a column with meaningless data into each SELECT table so that I could use it to join, as the tables had no other similarities.
The problem is that when you upload a report into CRM, if it uses filtered views, you don't have to go into Report Manager and change the data source from a shared to a custom data source. But on reports where I don't use the filtered views, I find that they always break when upload them, because they use the shared data source. This is the case even when I have created the report without the shared data source. So I usually have to go in and change the data source from shared to custom every time I upload a report without filtered views.
Because of the situation I described, this report uses both filtered views and non-filtered views (for the hard-coded columns). When I upload it into CRM, it won't work either way, with a shared or a custom data source.
Has anyone had this problem before?
View 1 Replies
View Related
Nov 28, 2006
Hi,
I created a report model. The data source view contains some tables and some views, however, in the report model window, I can see only the tables but not the views.
Can anybody tell me why?
View 2 Replies
View Related
Oct 23, 2007
I was wondering if it was possible to incorporate sql views or functions that filter data on the top bar for users when they run a report.
a response is greatly appreciated! If so, how?
View 1 Replies
View Related
Apr 3, 2006
Fellow database developers,I would like to draw on your experience with views. I have a databasethat includes many views. Sometimes, views contains other views, andthose views in turn may contain views. In fact, I have some views inmy database that are a product of nested views of up to 6 levels deep!The reason we did this was.1. Object-oriented in nature. Makes it easy to work with them.2. Changing an underlying view (adding new fields, removing etc),automatically the higher up views inherit this new information. Thismake maintenance very easy.3. These nested views are only ever used for the reporting side of ourapplication, not for the day-to-day database use by the application.We use Crystal Reports and Crystal is smart enough (can't believe Ijust said that about Crystal) to only pull back the fields that arebeing accessed by the report. In other words, Crystal will issue aSelect field1, field2, field3 from ReportingView Where .... eventhough "ReportingView" contains a long list of fields.Problems I can see.1. Parent views generally use "Select * From childview". This meansthat we have to execute a "sp_refreshview" command against all viewswhenever child views are altered.2. Parent views return a lot of information that isn't necessarilyused.3. Makes it harder to track down exactly where the information iscoming from. You have to drill right through to the child view to seethe raw table joins etc.Does anyone have any comments on this database design? I would love tohear your opinions and tales from the trenches.Best regards,Rod.
View 15 Replies
View Related
Sep 6, 2007
Which is more efficient? One large view that joins >=10 tables, or a few smaller views that join only the tables needed for individual pages?
View 1 Replies
View Related
Jan 10, 2007
Hi all ,
this is my first post here hope i will find help.
I'm facing problems in understanding some topics .. and i searched on the net but every time i read an article i find new things and topics.
i think i need just a good way to start from the following topics.
-recovery models (full,simple,..).
-fullback and differntial back up.
waiting for your help or even links to external articles may also help.
thanks in adavance
View 4 Replies
View Related
Jul 6, 2001
Any one knows if the recovery models in SQL7.0 same as in SQL2000, if not the same do you know them and which one is the default.
Saad
View 1 Replies
View Related
Apr 12, 2006
Hi,
If I'm using a transactional replication and the publisher's recovery model is se to FULL, can the subscribers use simple recovery model?
Thanks.
View 1 Replies
View Related
Dec 5, 2007
Hello Everybody , I have Some questions and I am sure that this is the best place for them to not be questions any more.
Here are My Questions:
What is the difference between full recovery model and simple recovery model?
My database has an mdf file about 400mb and a log file about 5GB.
Is this caused because of full recovery model?
What can I do in order to make my log file smaller?
Which recovery Model Do you Suggest for Use and Why?
Thank you So Very Much
I sell my mother in law.Is anybody interested?
View 12 Replies
View Related
Jul 20, 2005
Hi.Does anyone know any web site with common database models presented andexplained.Database models like calendar, adressbook, storehouse...Thnx in advance
View 1 Replies
View Related
Jan 25, 2007
I am using the Excel 2007 data mining add-in, and don't have write perms on the Analysis Services server. Can I store datamining models in an alternate location?
View 1 Replies
View Related
May 10, 2007
Hello
I've created models with Decision Tree and Neural Network algorithms that predict continous target. But I don't know how to interpret scores that occure under scatter accuracy plot. How should I interpret scores under scatter accuracy plot?
How can I estimate occuracy of model created with Time Series? How can I compare accuracy of model created with Time Series with models created with Decision Trees and Neural Network algorithms?
Thanks in advance.
View 5 Replies
View Related
Dec 19, 2006
Hi .Net Guru’s,I have an urgent requirement for my project; the issue is mentioned below;Using .Net(C#/VB.Net) I need to generate/created Database objects from XML schemas.I don't have any sample xml schema file to give you. You just imagine you have a sample .xsd file and this .xsd file will be used to create database tables.Please let me know if you have any queries. Thanks,nick
View 1 Replies
View Related
May 16, 2008
hi help me as soon , i need know ,i get for my teacher
View 1 Replies
View Related
Jul 16, 2007
Hi, guys,
Thanks for your kind attention.
Just want to make things perfectly work and make the most of our fantastic SQL Server 2005 Data Mining Engine. Can any of you here give me some super advices on the validation of the mining models. As we always see, the 3 aspects of a mining model are: Score, Population correct, and Predict Probability. So the question is: How can we combine these three aspects to best judge the mining models by being able to tell which model is the best one? And to what extent can we really trust these mining models?
These are very important before we can actually bring the models into work to convince other people who have no ideas what are going on with these models. Yes, we just want to convince them with the results of these models and make the most of them and best help them getting the most from their business operations etc.
By the way please can you explain a bit details on each of these aspects? Thanks again.
I am looking forward to hearing from you shortly and thanks bunch for your help.
With best regards,
Yours sincerely,
View 3 Replies
View Related
Jan 6, 2007
I've been experimenting with the algorithm parameters for a market basket association model. The default MINIMUM_ITEMSET_SIZE is 1. This doesn't seem to make sense: what is the point of a single-member itemset? However changing the value to 2 substantially reduces the proportion of good recommendations obtained (which I'm testing via a holdout approach).
So I'm obviously misunderstanding what the parameter means. Can someone explain it please, and also explain the observation above)?
View 1 Replies
View Related
Dec 5, 2006
Hi, all here,
Since we are not able to use accuracy chart for Clustering algorithms there. So how can we verify the accuracy of clustering algorithm models here in terms of its classification and regression tasks?
Thank you very much in advance for your guidance and advices for that.
With best regards,
Yours sincerely,
View 12 Replies
View Related
Oct 5, 2005
Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.
View 9 Replies
View Related
Jun 28, 2007
Hello.
Newbie here. I've only been using SQL for about a year now and have some minor questions about sql objects that reference other objects.
We have some views which reference other views in the joins. I will call one the primary view and the one being referenced in the joins as the secondary view.
Recently we made changes to the secondary view.
After which the primary views which referenced it would not work because of this change and had to be 'refreshed' by using drop/create scripts which essentially just dropped it and recreated the exact same view. I do not recall the exact error message that was returned other than it seemed to suggest that it could no longer see the secondary view since it had been changed. Nothing in the primary view was changed in any way, just the secondary.
Some here where I work have suggested off hand that this was a recompile of the primary view because the contents of the secondary changed.
My questions are:
1. Exactly why did this happen and is there a proper name for it when it does?
2. The same problem does not seem to occur when we have stored procedures referencing views in the joins which had just been changed. Why is that?
Thanks for any help on the matter. I greatly appreciate it.
View 3 Replies
View Related
Feb 22, 2007
Hello,
to make a report easier I'm developing it using a view of joined views of joined views.
Is there any significant performance penalty as opposed to just having one big select?
Cheers.
View 1 Replies
View Related
Aug 9, 2013
Find out the models and prices for all the products (of any type) produced by maker B.
Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)
Printer(code, model, color, type, price)
select product.type,
pc.price as pcprice,
laptop.price lapprice,
pc.model as pcmod,
laptop.model as lapmod
from product
join
pc on product.model=pc.model
join
laptop on laptop.model=product.model
where maker = 'B'
the syntex runs but its not displaying any results + I know that I have some extra columns there but its for some thing else I was trying
View 3 Replies
View Related
Jun 12, 2006
Hi, all here,
I am having a question about automating data mining models managements. As we know in many businesses, patterns vary very frequently, therefore, the mining models created will need to be created again afterwards according to new rules appearing in the data. But can we make all these process automated like automatically assessing the mining model accuracy and automatically recreate the mining models based on predifined specifications? Would please any one here give me any idea about that?
Thanks a lot for any guidance and help for that.
With best regards,
View 3 Replies
View Related
