Monday, March 26, 2012
I was getting an unspecified error....
Friday, March 23, 2012
I want urgent help
I have created cube in sql server 2005. I want to use that cube from the front end that is using asp.net application I know that for this u require OWC(Office Web Component). I have installed that also. So can anybody help me to integrate all these stubs together.
Thanks In advance
Sach
Try this You will not need OWC. Remember OWC is not going to be supported in future.
The CellSetGrid is open source ASP.NET based OLAP browser: http://www.sqlserveranalysisservices.com/cellsetgrid/CellSetGridIntro.htm
I doesn't mean to sell you different solutions to you but If you need Web interface for Cube also try Sharepoint Services and Pivot Table web part. I found best solution, quick and free if you have Windows 2003 Server OS. But yes you will be using OWC in this case.
- Ashok
I want to show sales price
Hello
I have a cube and I need to show sales price but if I use like atributte i can show the sales price at the moment sale.
Can you heep me?
Please,
can you post more details to better understand your problem?
Francesco
|||Sorry but my English is not good.
I have a Dimension Product and Sales Fact Table
My DIm have this attributes: Album, Artist ,Track Name and Price
My Fact Table has this columns PoroductID, Quanty, SalesPrice, Total
And in the fact table I calculate the total to avoid make a calculated mesure.
But the price can change in the future, and I need a Report like this
Track Name, Quantity, Price, Total
I love you, 3, $5.00, $15.00
But if the price chnge in the future. How Can I show the Price at the moment of the sale.
Thanks
|||Well I'll try to make the things simple...
You have a fact table with a foreign key to your dimension table.
Some information are stored in the fact table (your facts/measures) and others (attributes of facts) are stored in dimension table.
Usually you have a date dimension because you make a "snapshot" of your facts and put it into your fact table, so you have to record the date of that snapshot.
Well, in your case, if I've understood, you have a "SalesPrice" that is your fact.
Probably you record in that column the value of the price at the moment of the sale.
So if you query that value for a certain date you'll obtain the value of the price at "that" date.
In the dimension you'll record the price of the product at the date .... it depends from what kind of dimension (or what kind of update you usally do to that dimension)
If you have a SCD (Slowly Changing Dimension) type I you update the value every time you update dimension so you'll have ever the last value
If you choose a SCD type II you'll register every changing in dimension value adding new member. In this way you record all the story of the dimension because every member is a "snapshot" at a certain date of the entity it represent.
As I told the story is longer, but you can find more information on BOL, on the WEB and in almost every book about SSAS.
Francesco
|||Thanks a lot!!
|||Hello Again
I nedd to show the TOP 100 most sales tracks.
Do you have an idea?
Thanks
sqlI want to show sales price
Hello
I have a cube and I need to show sales price but if I use like atributte i can show the sales price at the moment sale.
Can you heep me?
Please,
can you post more details to better understand your problem?
Francesco
|||Sorry but my English is not good.
I have a Dimension Product and Sales Fact Table
My DIm have this attributes: Album, Artist ,Track Name and Price
My Fact Table has this columns PoroductID, Quanty, SalesPrice, Total
And in the fact table I calculate the total to avoid make a calculated mesure.
But the price can change in the future, and I need a Report like this
Track Name, Quantity, Price, Total
I love you, 3, $5.00, $15.00
But if the price chnge in the future. How Can I show the Price at the moment of the sale.
Thanks
|||Well I'll try to make the things simple...
You have a fact table with a foreign key to your dimension table.
Some information are stored in the fact table (your facts/measures) and others (attributes of facts) are stored in dimension table.
Usually you have a date dimension because you make a "snapshot" of your facts and put it into your fact table, so you have to record the date of that snapshot.
Well, in your case, if I've understood, you have a "SalesPrice" that is your fact.
Probably you record in that column the value of the price at the moment of the sale.
So if you query that value for a certain date you'll obtain the value of the price at "that" date.
In the dimension you'll record the price of the product at the date .... it depends from what kind of dimension (or what kind of update you usally do to that dimension)
If you have a SCD (Slowly Changing Dimension) type I you update the value every time you update dimension so you'll have ever the last value
If you choose a SCD type II you'll register every changing in dimension value adding new member. In this way you record all the story of the dimension because every member is a "snapshot" at a certain date of the entity it represent.
As I told the story is longer, but you can find more information on BOL, on the WEB and in almost every book about SSAS.
Francesco
|||Thanks a lot!!
|||Hello Again
I nedd to show the TOP 100 most sales tracks.
Do you have an idea?
Thanks
Monday, March 12, 2012
I tried deploying an SSAS project under SQL 2005 dev server, but, deployment fails
This project is with multi data sources, multi cube - when I deploy, I get the following error:
Error 1 Either the 'MELLONBANK\ADCDT2Q' user does not have permission to create a new object in 'SMAMSQL5DEV', or the object does not exist. 0 0
I tried from SQL Server Management studio, I can create tables, write to it fine.
I asked the DBA whether permission problem - she said if SSIS is trying to write to file, there might be some problems, but, database creation shouldn't be a problem. My question is does SSIS try to write some XML when I deploy - my guess is it does with all the properties written in XML. Just trying to confirm with you guys!|||I assume that you were actually talking about SSAS, not SSIS in your previous post.
The fact that you get this error when deploying an SSAS project means that you are not in the Admin group for SSAS. SSAS is different to the SQL Server relational engine and the fact that you could create tables/databases there does not mean that you have permissions to do this in SSAS.
You will need an Administrator (maybe the person who installed SSAS) to open up SQL Server Management Studio and do 1 of 2 things.
either.
1) Right click on the server, go to properties, click on the security option and add your user account - this will set you up as an SSAS administrator, which will let you create new databases.
Or
2) Create an empty database for you, add a role with your user account and set this role to have admin priviledges just on this database.
|||My Admin has created an empty database and an Role for Me with Admin Permission,
but I am Still not able to Deploy the Solution with BIDS.
Error was "Für die XYZ-Datenbank wurde ein Identit?tswechselmodus festgelegt, der für Serveradministratoren reserviert ist."
if i freely translate to englisch "For the database xyz a identityimpersonationmode was set that is reserved for system administrators"
Whats wrong there?
Best Regards
HANNES
|||This has to do with how your datasource is configured. If you are not an admin, you cannot deploy a database that has a datasource with the identityImpersonate property set to something like ImpersonateServiceAccount. This is to prevent you possibly getting access to a connection with higher priviledges than your user account. You will either need to set the impersonation mode to another value. If you need it to be set like it is then you could get the admin to change it for you after deployment, the make sure you only deploy changed values or use the Database Deployment Wizard to deploy without the datasources.I tried deploying an SSAS project under SQL 2005 dev server, but, deployment fails
This project is with multi data sources, multi cube - when I deploy, I get the following error:
Error 1 Either the 'MELLONBANK\ADCDT2Q' user does not have permission to create a new object in 'SMAMSQL5DEV', or the object does not exist. 0 0
I tried from SQL Server Management studio, I can create tables, write to it fine.
I asked the DBA whether permission problem - she said if SSIS is trying to write to file, there might be some problems, but, database creation shouldn't be a problem. My question is does SSIS try to write some XML when I deploy - my guess is it does with all the properties written in XML. Just trying to confirm with you guys!|||I assume that you were actually talking about SSAS, not SSIS in your previous post.
The fact that you get this error when deploying an SSAS project means that you are not in the Admin group for SSAS. SSAS is different to the SQL Server relational engine and the fact that you could create tables/databases there does not mean that you have permissions to do this in SSAS.
You will need an Administrator (maybe the person who installed SSAS) to open up SQL Server Management Studio and do 1 of 2 things.
either.
1) Right click on the server, go to properties, click on the security option and add your user account - this will set you up as an SSAS administrator, which will let you create new databases.
Or
2) Create an empty database for you, add a role with your user account and set this role to have admin priviledges just on this database.
|||My Admin has created an empty database and an Role for Me with Admin Permission,
but I am Still not able to Deploy the Solution with BIDS.
Error was "Für die XYZ-Datenbank wurde ein Identit?tswechselmodus festgelegt, der für Serveradministratoren reserviert ist."
if i freely translate to englisch "For the database xyz a identityimpersonationmode was set that is reserved for system administrators"
Whats wrong there?
Best Regards
HANNES
|||This has to do with how your datasource is configured. If you are not an admin, you cannot deploy a database that has a datasource with the identityImpersonate property set to something like ImpersonateServiceAccount. This is to prevent you possibly getting access to a connection with higher priviledges than your user account. You will either need to set the impersonation mode to another value. If you need it to be set like it is then you could get the admin to change it for you after deployment, the make sure you only deploy changed values or use the Database Deployment Wizard to deploy without the datasources.I think i killed Analysis Services (05), need a reset button
I'm a cube rookie and have been deploying funky cubes while i'm cutting my teeth on AS. Unfortunately, AS has completely stopped responding, connecting to it in SQL Server Management studio or BI Studio just results in a hang. The service will stop and start without error in the Event log, but i can't interact with it any more. Restarting the PC doesn't help...
I tried to uninstall it, but setup is forcing me to uninstal SQL server with it, which isn't a good idea for me at this point. Is there any way to 'reset' AS?
Thanks!
Edited To Add:
Well, i've blown away any file i could find under this directory that appeared to have anything to do with my cube and i can now connect to AS...wish me luck!
C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP
Apparently in spur of the moment you killed too much :)
The files you needed to delete were under C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data
Now you probably have no choice but uninstall and re-install the product again.
Run Remove for SQL Server, later in the uninstall wizard you should be able choose to remove Analysis Services only.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Fortunately I just left the detail out of my post, and only deleted the files under Data. So far things have been working well. I'm still learning a lot about how to put this stuff together, but the difference in performance between this and Access Pivot tables makes it all worth while.
Thanks!
Friday, February 24, 2012
I need help with xmla query
I need to do a xmla query for calling more than one prespective. For example:
I have a cube with 4 perspectives, but in the xmla query only need 2 perspectives.
Cube: Censo
Perspectives: Depto.
Pais
Principal
Privado
But i only need
Cube: Censo
Perspectives: Depto
PaisI'm not sure I entirely understand your question, but if you need to reference objects from 2 different prespectives you should be able to just query the underlying cube.|||Sorry if i don't explain well my question... but here put a example.
I have this query:
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>MDSCHEMA_CUBES</RequestType>
<Restrictions>
<RestrictionList>
<CUBE_NAME>Depto</CUBE_NAME>
<CUBE_NAME>País</CUBE_NAME>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<DataSourceInfo>SERVER</DataSourceInfo>
<Catalog>Censo</Catalog>
<Format>Tabular</Format>
<Content>SchemaData</Content>
</PropertyList>
</Properties>
</Discover>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
With this query only show me the País perspective, but i want show me Depto and País perspective because the cube have 4 perspectives.|||
Thanks for the example, now I understand what your are after. :)
Unfortunately I don't think you can have more than one CUBE_NAME element in your restriction list. What I believe is happening is that the value is being overwritten and the last one is the one that is used.
I think you have 2 options
1) fire off 2 separate Discover requests, one for each perspective
2) do not put any restrictions in the request and filter the results on the client side.
I need help with xmla query
I need to do a xmla query for calling more than one prespective. For example:
I have a cube with 4 perspectives, but in the xmla query only need 2 perspectives.
Cube: Censo
Perspectives: Depto.
Pais
Principal
Privado
But i only need
Cube: Censo
Perspectives: Depto
PaisI'm not sure I entirely understand your question, but if you need to reference objects from 2 different prespectives you should be able to just query the underlying cube.|||Sorry if i don't explain well my question... but here put a example.
I have this query:
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>MDSCHEMA_CUBES</RequestType>
<Restrictions>
<RestrictionList>
<CUBE_NAME>Depto</CUBE_NAME>
<CUBE_NAME>País</CUBE_NAME>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<DataSourceInfo>SERVER</DataSourceInfo>
<Catalog>Censo</Catalog>
<Format>Tabular</Format>
<Content>SchemaData</Content>
</PropertyList>
</Properties>
</Discover>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
With this query only show me the País perspective, but i want show me Depto and País perspective because the cube have 4 perspectives.|||
Thanks for the example, now I understand what your are after. :)
Unfortunately I don't think you can have more than one CUBE_NAME element in your restriction list. What I believe is happening is that the value is being overwritten and the last one is the one that is used.
I think you have 2 options
1) fire off 2 separate Discover requests, one for each perspective
2) do not put any restrictions in the request and filter the results on the client side.