text:
Norman Ackroyd (1938 – )
WESTMERE EVENING 1980 Norman Ackroyd (1938 – )	P4936 © The Artist
SWINBROOK MEADOWS 1980 Norman Ackroyd (1938 – )	P4935 © The Artist
Next See all (38)
Norman Ackroyd was born in Leeds, Yorkshire; he studied at the local art school and later at the Royal College of Art in London. He has taught at a number of art schools in the United Kingdom and was appointed a Royal Academician in 1991. The subject matter of his work is mostly landscape, atmospherically seen through mists or at the break and end of day.
www.normanackroyd.com
www.royalacademy.org.uk
Landscape is one of the principle genres of Western art. In early paintings the landscape was a backdrop for the composition, but in the late 17th Century the appreciation of nature for its own sake began with the French and Dutch painters (from whom the term derived). Their treatment of the landscape differed: the French tried to evoke the classical landscape of ancient Greece and Rome in a highly stylised and artificial manner; the Dutch tried to paint the surrounding fields, woods and plains in a more realistic way. As a genre, landscape grew increasing popular, and by the 19th Century had moved away from a classical rendition to a more realistic view of the natural world. Two of the greatest British landscape artists of that time were John Constable and JMW Turner, whose works can be seen in the Tate collection (www.tate.org.uk). There can be no doubt that the evolution of landscape painting played a decisive role in the development of Modernism, culminating in the work of the Impressionists and Post-Impressionists . Since then its demise has often been predicted and with the rise of abstraction, landscape painting was thought to have degenerated into an amateur pursuit. However, landscape persisted in some form into high abstraction, and has been a recurrent a theme in most of the significant tendencies of the 20th Century. Now manifest in many media, landscape no longer addresses solely the depiction of topography, but encompasses issues of social, environmental and political concern.
ARTISTS' CHOICE
NINE LONDON BIRDS
TWELVE ARTISTS THE ROYAL COLLEGE OF ART CENTENARY YEAR PORTFOLIO OF PRINTS
Albania, Tirana, National Gallery
Croatia, Osijek, Galerija Likovbih Umjetnosti
Croatia, Zagreb, British Council Office - Zagreb
Jamaica, Kingston, National Gallery Of Jamaica
Barbados, St Michael, Barbados Museum And Historical Society
Barbados, St Michael, Central Bank Gallery
Ecuador, Ecuador
Brazil, Brazil
Pakistan, Pakistan
Turkey, Turkey
Zimbabwe, Zimbabwe
Nigeria, Nigeria
British Council Office - Lilongwe
Ghana, Accra, British Council Office - Accra
China, China
BRITISH ARTISTS' PRINTS 1972-1977
Morocco, Morocco
Canada, Canada
Iraq, Iraq
Egypt, Cairo, Cairo
United Arab Emirates, United Arab Emirates
Qatar, Doha, Doha
Spain, Zamora, Casa De La Cultura
Jordan, Jordan
South Africa, South Africa
Finland, Finland
Finland, Helsinki, Helsinki
Greece, Athens, Athens
Norway, Frederikstad
BRITISH PRINTMAKERS 1968-1970
Circulating Exhibition, BC Circulating Exhibition -


1.What is the difference between SSAS 2005 and SSAS 2008?
In 2005 its not possible to create an empty cube but in 2008 we can create an empty cube.
we can create ONLY 2000 partitions per Measure Group in ssas 2005 and the same limit of partitions is removed in ssas 2008.
2. What is data warehouse in short DWH?
Collection of data in support of management's decision making process". He defined the terms in the sentence as follows.
It define the specific business domain ex: banking, retail, insurance, etc…..
It should be in a position to maintain the data the various time periods.
3. What is data mart?
A data mart is a subset of an organizational data store, usually oriented to a specific purpose or major data subject that may be distributed to support business needs. Data marts are analytical data stores designed to focus on specific business functions for a specific community within an organization.
Data marts are often derived from subsets of data in a data warehouse, though in the bottom-up data warehouse design methodology the data warehouse is created from the union of organizational data marts.
4. What are the difference between data mart and data warehouse?
Data warehouse is complete data where as Data mart is Subset of the same.
All the organisation data may related to finance department, HR, banking dept are stored in data warehouse where as in data mart only finance data or HR department data will be stored. So data warehouse is a collection of different data marts.
5. Have you ever worked on performance tuning, if yes what are the steps involved in it?
We need to identify the bottlenecks to tune the performance, to overcome the bottleneck we need to following the following.
Won't take even single measure which is not necessary.
6. What are the difficulties faced in cube development?
7. Explain the flow of creating a cube?
Create a data source view.
Deploy and Process the cube.
8. What is a datasource or DS?
The data source is the Physical Connection information that analysis service uses to connect to the database that host the data. The data source contains the connection string which specifies the server and the database hosting the data as well as any necessary authentication credentials.
What is data source view or DSV?
A data source view is a persistent set of tables from a data source that supply the data for a particular cube. BIDS also includes a wizard for creating data source views, which you can invoke by right-clicking on the Data Source Views folder in Solution Explorer.
Data source view is the logical view of the data in the data source.
Data source view is the only thing a cube can see.
9. What is named calculation?
A named calculation is a SQL expression represented as a calculated column. This expression appears and behaves as a column in the table. A named calculation lets you extend the relational schema of existing tables or views in a data source view without modifying the tables or views in the underlying data source.
Named calculation is used to create a new column in the DSV using hard coded values or by using existing columns or even with both.
10. What is named query?
Named query in DSV is similar to View in Database. This is used to create Virtual table in DSV which will not impact the underlying database. Named query is mainly used to merge the two or more table in the datasource view or to filter columns of a table.
11. Why we need named queries?
A named query is used to join multiple tables, to remove unnecessary columns from a table of a database. You can achieve the same in database using Views but this Named Queries will be the best bet whe you don't have access to create Views in database.
12. How will you add a new column to an existing table in data source view?
By using named calculations we can add a new column to an existing table in the data source view. Named Calculation is explained above.
13. What is dimension table?
The primary key column of each dimension table corresponding to the one of the key column in any related fact table.
14. What is fact table?
A fact table contains the basic information that you wish to summarize. The table that stores the detailed value for measure is called fact table. In simple and best we can define as "The table which contains METRICS" that are used to analyse the business.
Desired to gain proficiency on SSAS?
Explore the blog post on SSAS training to become a pro in SSAS.
15. What is Factless fact table?
The "Factless Fact Table" is a table which is similar to Fact Table except for having any measure; I mean that this table just has the links to the dimensions. These tables enable you to track events; indeed they are for recording events.
16. What is attribute relationships, why we need it?
Attribute relationships are the way of telling the analysis service engine that how the attributes are related with each other. It will help to relate two or more attributes to each other.Processing time will be decreased if proper relationships are given. This increases the Cube Processing performance and MDX query performance too.
- Between the key attribute and each non-key attribute bound to columns in the main dimension table.
- Between the key attribute and the attribute bound to the foreign key in the secondary table that links the underlying dimension tables.
- Between the attribute bound to foreign key in the secondary table and each non-key attribute bound to columns from the secondary table.
17. How many types of attribute relationships are there?
Rigid: In Rigid relationships where the relationship between the attributes is fixed, attributes will not change levels or their respective attribute relationships.
Example: The time dimension. We know that month "January 2009″ will ONLY belong to Year "2009″ and it wont be moved to any other year.
Flexible : In Flexible relationship between the attributes is changed.
Example: An employee and department. An employee can be in accounts department today but it is possible that the employee will be in Marketing department tomorrow.
18. How many types of dimensions are there and what are they?
19. What are confirmed dimensions, junk dimension and degenerated dimensions?
Confirm dimension: It is the dimension which is sharable across the multiple facts or data model. This is also called as Role Playing Dimensions.
junk dimension: A number of very small dimensions might be lumped (a small irregularly shaped) together to form a single dimension, a junk dimension – the attributes are not closely related. Grouping of Random flags and text Attributes in a dimension and moving them to a separate sub dimension is known as junk dimension.
Degenerated dimension: In this degenerate dimension contains their values in fact table and the dimension id not available in dimension table. Degenerated Dimension is a dimension key without corresponding dimension.
Date Dimension corresponds to Date Key, Production Dimension corresponds to Production Key. In a traditional parent-child database, POS Transactional Number would be the key to the transaction header record that contains all the info valid for the transaction as a whole, such as the transaction date and store identifier. But in this dimensional model, we have already extracted this info into other dimension. Therefore, POS Transaction Number looks like a dimension key in the fact table but does not have the corresponding dimension table.
20. What are the types of database schema?
21. What is star, snowflake and star flake schema?
Star schema: In star schema fact table will be directly linked with all dimension tables. The star schema's dimensions are denormalized with each dimension being represented by a single table. In a star schema a central fact table connects a number of individual dimension tables.
Snowflake: The snowflake schema is an extension of the star schema, where each point of the star explodes into more points. In a star schema, each dimension is represented by a single dimensional table, whereas in a snowflake schema, that dimensional table is normalized into multiple lookup tables, each representing a level in the dimensional hierarchy. In snow flake schema fact table will be linked directly as well as there will be some intermediate dimension tables between fact and dimension tables.
Star flake: A hybrid structure that contains a mixture of star(denormalized) and snowflake(normalized) schema's.
22.How will you hide an attribute?
We can hide the attribute by selecting "AttributeHierarchyVisible = False" in properties of the attribute.
23. How will you make an attribute not process?
By selecting " AttributeHierarchyEnabled = False", we can make an attribute not in process.
24. What is use of IsAggregatable property?
In Analysis Service we generally see all dimension has All member. This is because of IsAggregatable property of the attribute. You can set its value to false, so that it will not show All member. Its default member for that attribute. If you hide this member than you will have to set other attribute value to default member else it will pick some value as default and this will create confusion in browsing data if someone is not known to change in default member.
25. What are key, name and value columns of an attribute?
Key column of any attribute: Contains the column or columns that represent the key for the attribute, which is the column in the underlying relational table in the data source view to which the attribute is bound. The value of this column for each member is displayed to users unless a value is specified for the NameColumn property.
Name column of an attribute: Identifies the column that provides the name of the attribute that is displayed to users, instead of the value in the key column for the attribute. This column is used when the key column value for an attribute member is cryptic or not otherwise useful to the user, or when the key column is based on a composite key. The NameColumn property is not used in parent-child hierarchies; instead, the NameColumn property for child members is used as the member names in a parent-child hierarchy.
Value columns of an attribute: Identifies the column that provides the value of the attribute. If the NameColumn element of the attribute is specified, the same DataItem values are used as default values for the ValueColumn element. If the NameColumn element of the attribute is not specified and the KeyColumns collection of the attribute contains a single KeyColumn element representing a key column with a string data type, the same DataItem values are used as default values for the ValueColumn element.
26. What is hierarchy, what are its types and difference between them?
hierarchies is made up of multiple levels creating the structure based on end user requirements.
Natural hierarchy: This means that the attributes are intuitively related to one another. There is a clear relationship from the top of the hierarchy to the bottom.
Example: An example of this would be date: year, quarter and month follow from each other, and in part, define each other.
Unnatural hierarchy: This means that the attributes are not clearly related.
Example: An example of this might be geography; we may have country -> state -> city, but it is not clear where Province might sit.
27. What is Attribute hierarchy?
An attribute hierarchy is created for every attribute in a dimension, and each hierarchy is available for dimensioning fact data. This hierarchy consists of an "All" level and a detail level containing all members of the hierarchy.
you can organize attributes into user-defined hierarchies to provide navigation paths in a cube. Under certain circumstances, you may want to disable or hide some attributes and their hierarchies.
28. What is use of AttributeHierarchyDisplayFolder property ?
AttributeHierarchyDisplayFolder: Identifies the folder in which to display the associated attribute hierarchy to end users. For example if I set the property value as "Test" to all the Attributes of a dimension then a folder with the name "Test" will be created and all the Attributes will be placed into the same.
30. What is use of AttributeHierarchyEnabled?
AttributeHierarchyEnabled: Determines whether an attribute hierarchy is generated by Analysis Services for the attribute. If the attribute hierarchy is not enabled, the attribute cannot be used in a user-defined hierarchy and the attribute hierarchy cannot be referenced in Multidimensional Expressions (MDX) statements.
31. What is use of AttributeHierarchyOptimizedState?
AttributeHierarchyOptimizedState: Determines the level of optimization applied to the attribute hierarchy. By default, an attribute hierarchy is FullyOptimized, which means that Analysis Services builds indexes for the attribute hierarchy to improve query performance. The other option, NotOptimized, means that no indexes are built for the attribute hierarchy. Using NotOptimized is useful if the attribute hierarchy is used for purposes other than querying, because no additional indexes are built for the attribute. Other uses for an attribute hierarchy can be helping to order another attribute.
32. What is use of AttributeHierarchyOrdered ?
AttributeHierarchyOrdered: Determines whether the associated attribute hierarchy is ordered. The default value is True. However, if an attribute hierarchy will not be used for querying, you can save processing time by changing the value of this property to False.
33. What is the use of AttributeHierarchyVisible ?
AttributeHierarchyVisible : Determines whether the attribute hierarchy is visible to client applications. The default value is True. However, if an attribute hierarchy will not be used for querying, you can save processing time by changing the value of this property to False.
34. What are types of storage modes?
35. What is MOLAP and its advantage?
MOLAP (Multi dimensional Online Analytical Processing) : MOLAP is the most used storage type. Its designed to offer maximum query performance to the users. the data and aggregations are stored in a multidimensional format, compressed and optimized for performance. This is both good and bad. When a cube with MOLAP storage is processed, the data is pulled from the relational database, the aggregations are performed, and the data is stored in the AS database. The data inside the cube will refresh only when the cube is processed, so latency is high.
Since the data is stored on the OLAP server in optimized format, queries (even complex calculations) are faster than ROLAP.
The data is compressed so it takes up less space.
And because the data is stored on the OLAP server, you don't need to keep the connection to the relational database.
Cube browsing is fastest using MOLAP.
36. What is ROLAP and its advantage?
ROLAP (Relational Online Analytical Processing) : ROLAP does not have the high latency disadvantage of MOLAP. With ROLAP, the data and aggregations are stored in relational format. This means that there will be zero latency between the relational source database and the cube.
Disadvantage of this mode is the performance, this type gives the poorest query performance because no objects benefit from multi dimensional storage.
Since the data is kept in the relational database instead of on the OLAP server, you can view the data in almost real time.
Also, since the data is kept in the relational database, it allows for much larger amounts of data, which can mean better scalability.
37. What is HOLAP and its advantage?
Hybrid Online Analytical Processing (HOLAP): HOLAP is a combination of MOLAP and ROLAP. HOLAP stores the detail data in the relational database but stores the aggregations in multidimensional format. Because of this, the aggregations will need to be processed when changes are occur. With HOLAP you kind of have medium query performance: not as slow as ROLAP, but not as fast as MOLAP. If, however, you were only querying aggregated data or using a cached query, query performance would be similar to MOLAP. But when you need to get that detail data, performance is closer to ROLAP.
HOLAP is best used when large amounts of aggregations are queried often with little detail data, offering high performance and lower storage requirements.
Cubes are smaller than MOLAP since the detail data is kept in the relational database.
Processing time is less than MOLAP since only aggregations are stored in multidimensional format.
Low latency since processing takes place when changes occur and detail data is kept in the relational database.
38. What are Translations and its use?
Translation: The translation feature in analysis service allows you to display caption and attributes names that correspond to a specific language. It helps in providing GLOBALIZATION to the Cube.
39. What is Database dimension?
All the dimensions that are created using NEW DIMENSION Wizard are database dimensions. In other words, the dimensions which are at Database level are called Database Dimensions.
40. What is Cube dimension?
41. Difference between Database dimension and Cube dimension?
The Database dimension has only Name and ID properties, whereas a Cube dimension has several more properties.
Database dimension is created one where as Cube dimension is referenced from database dimension.
Database dimension exists only once.where as Cube dimensions can be created more than one using ROLE PLAYING Dimensions concept.
42. How will you add a dimension to cube?
To add a dimension to a cube follow these steps.
In Solution Explorer, right-click the cube, and then click View Designer.
In the Design tab for the cube, click the Dimension Usage tab.
Either click the Add Cube Dimension button, or right-click anywhere on the work surface and then click Add Cube Dimension.
To add an existing dimension, select the dimension, and then click OK.
To create a new dimension to add to the cube, click New dimension, and then follow the steps in the Dimension Wizard.
43. What is SCD (slowly changing dimension)?
Slowly changing dimensions (SCD) determine how the historical changes in the dimension tables are handled. Implementing the SCD mechanism enables users to know to which category an item belonged to in any given date.
44. What are types of SCD?
45. What is Type1, Type2, Type3 of SCD?
Type 1: In Type 1 Slowly Changing Dimension, the new information simply overwrites the original information. In other words, no history is kept.
Advantages: This is the easiest way to handle the Slowly Changing Dimension problem, since there is no need to keep track of the old information.
Disadvantages: All history is lost. By applying this methodology, it is not possible to trace back in history.
Usage: About 50% of the time.
When to use Type 1: Type 1 slowly changing dimension should be used when it is not necessary for the data warehouse to keep track of historical changes.
Type 2: In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. The new record gets its own primary key.
Advantages: This allows us to accurately keep all historical information.
This will cause the size of the table to grow fast. In cases where the number of rows for the table is very high to start with, storage and performance can become a concern.
This necessarily complicates the ETL process.
Type3 : In Type 3 Slowly Changing Dimension, there will be two columns to indicate the particular attribute of interest, one indicating the original value, and one indicating the current value. There will also be a column that indicates when the current value becomes active.
This does not increase the size of the table, since new information is updated.
This allows us to keep some part of history.
Disadvantages: Type 3 will not be able to keep all history where an attribute is changed more than once. For example, if Christina later moves to Texas on December 15, 2003, the California information will be lost.
Usage: Type 3 is rarely used in actual practice.
46. What is role playing dimension with two examples?
Role play dimensions: We already discussed about this. This is nothing but CONFIRMED Dimensions. A dimension can play different role in a fact table you can recognize a roleplay dimension when there are multiple columns in a fact table that each have foreign keys to the same dimension table.
Ex1: There are three dimension keys in the factinternalsales,factresellersales tables which all refer to the dimtime table,the same time dimension is used to track sales by that contain either of these fact table,the corresponding role-playing dimension are automatically added to the cube.
Ex2 : In retail banking, for checking account cube we could have transaction date dimension and effective date dimension. Both dimensions have date, month, quarter and year attributes. The formats of attributes are the same on both dimensions, for example the date attribute is in 'dd-mm-yyyy' format. Both dimensions have members from 1993 to 2010.
What is measure group, measure?
Measure groups : These measure groups can contain different dimensions and be at different granularity but so long as you model your cube correctly, your users will be able to use measures from each of these measure groups in their queries easily and without worrying about the underlying complexity.
Creating multiple measure groups : To create a new measure group in the Cube Editor, go to the Cube Structure tab and right-click on the cube name in the Measures pane and select 'New Measure Group'. You'll then need to select the fact table to create the measure group from and then the new measure group will be created; any columns that aren't used as foreign key columns in the DSV will automatically be created as measures, and you'll also get an extra measure of aggregation type Count. It's a good idea to delete any measures you are not going to use at this stage.
Measures : Measures are the numeric values that our users want to aggregate, slice, dice and otherwise analyze, and as a result, it's important to make sure they behave the way we want them to. One of the fundamental reasons for using Analysis Services is that, unlike a relational database it allows us to build into our cube design business rules about measures: how they should be formatted, how they should aggregate up, how they interact with specific dimensions and so on.
An attribute is a specification that defines a property of an object, element, or file. It may also refer to or set the specific value for a given instance of such.
48. What is surrogate key?
A surrogate key is the SQL generated key which acts like an alternate primary key for the table in database, Data warehouses commonly use a surrogate key to uniquely identify an entity. A surrogate is not generated by the user but by the system. A primary difference between a primary key and surrogate key in few databases is that primarykey uniquely identifies a record while a Surrogatekey uniquely identifies an entity.
Ex: An employee may be recruited before the year 2000 while another employee with the same name may be recruited after the year 2000. Here, the primary key will uniquely identify the record while the surrogate key will be generated by the system (say a serial number) since the SK is NOT derived from the data.
49. How many types of relations are there between dimension and measure group?
50. What is regular type, no relation type, fact type, referenced type, many-to-many type with example?
No relationship: The dimension and measure group are not related.
Regular: The dimension table is joined directly to the fact table.
Referenced: The dimension table is joined to an intermediate table, which in turn,is joined to the fact table.
Many to many:The dimension table is to an intermediate fact table,the intermediate fact table is joined , in turn, to an intermediate dimension table to which the fact table is joined.
Data mining:The target dimension is based on a mining model built from the source dimension. The source dimension must also be included in the cube.
Fact table: The dimension table is the fact table.
51. What are calculated members and what is its use?
Calculated members: You can create customized measures or dimension members, called calculated members, by combining cube data, arithmetic operators, numbers, and/or functions.
Example: You can create a calculated member called Marks that converts dollars to marks by multiplying an existing dollar measure by a conversion rate. Marks can then be displayed to end users in a separate row or column. Calculated member definitions are stored, but their values exist only in memory. In the preceding example, values in marks are displayed to end users but are not stored as cube data.
52. What are KPIs and what is its use?
53. What are actions, how many types of actions are there, explain with example?
Actions are powerful way of extending the value of SSAS cubes for the end user. They can click on a cube or portion of a cube to start an application with the selected item as a parameter, or to retrieve information about the selected item.
Analysis Services supports three types of actions..
Report action: Report action Returns a Reporting Services report that is associated with the cube data on which the action is based.
Drill through: Drill through Returns a result set that provides detailed information related to the cube data on which the action is based.
Standard: Standard has five action subtypes that are based on the specified cube data.
Dataset: Returns a mutlidimensional dataset.
Proprietary: Returns a string that can be interpreted by a client application.
Rowset: Returns a tabular row set.
Statement: Returns a command string that can be run by a client application.
URL: Returns a URL that can be opened by a client application, usually a browser.
54. What is partition, how will you implement it?
You can use the Partition Wizard to define partitions for a measure group in a cube. By default, a single partition is defined for each measure group in a cube. Access and processing performance, however, can degrade for large partitions. By creating multiple partitions, each containing a portion of the data for a measure group, you can improve the access and processing performance for that measure group.
55. What is the minimum and maximum number of partitions required for a measure group?
In 2005 a MAX of 2000 partitions can be created per measure group and that limit is lifted in later versions.
In any version the MINIMUM is ONE Partition per measure group.
56. What are Aggregations and its use?
Selecting standard or custom settings for the storage and caching options of a partition, measure group, or cube.
Providing estimated or actual counts for objects referenced by the partition, measure group, or cube.
Specifying aggregation options and limits to optimize the storage and query performance delivered by designed aggregations.
Saving and optionally processing the partition, measure group, or cube to generate the defined aggregations.
After you use the Aggregation Design Wizard, you can use the Usage-Based Optimization Wizard to design aggregations based on the usage patterns of the business users and client applications that query the cube.
57. What is perspective, have you ever created perspective?
Perspectives are a way to reduce the complexity of cubes by hidden elements like measure groups, measures, dimensions, hierarchies etc. It's nothing but slicing of a cube, for ex we are having retail and hospital data and end user is subscribed to see only hospital data, then we can create perspective according to it.
58. What is deploy, process and build?
Bulid: Verifies the project files and create several local files.
Deploy: Deploy the structure of the cube(Skeleton) to the server.
Elaborating the same is given below.
Build: Its is a used to process the data of the cube database. Build is a version of a program. As a rule, a build is a pre-release version and as such is identified by a build number, rather than by a release number. Reiterative (repeated) builds are an important part of the development process. Throughout development, application components are collected and repeatedly compiled for testing purposes, to ensure a reliable final product. Build tools, such as make or Ant, enable developers to automate some programming tasks. As a verb, to build can mean either to write code or to put individual coded components of a program together.
Deployment: During development of an Analysis Services project in Business Intelligence Development Studio, you frequently deploy the project to a development server in order to create the Analysis Services database defined by the project. This is required to test the project.
for example, to browse cells in the cube, browse dimension members, or verify key performance indicators (KPIs) formulas.
59. What is the maximum size of a dimension?
The maximum size of the dimension is 4 gb.
60. What are the types of processing and explain each?
Process Full: Processes an Analysis Services object and all the objects that it contains. When Process Full is executed against an object that has already been processed, Analysis Services drops all data in the object, and then processes the object. This kind of processing is required when a structural change has been made to an object, for example, when an attribute hierarchy is added, deleted, or renamed. This processing option is supported for cubes, databases, dimensions, measure groups, mining models, mining structures, and partitions.
Process Data: Processes data only without building aggregations or indexes. If there is data is in the partitions, it will be dropped before re-populating the partition with source data. This processing option is supported for dimensions, cubes, measure groups, and partitions.
Process Index: Creates or rebuilds indexes and aggregations for all processed partitions. This option causes an error on unprocessed objects. This processing option is supported for cubes, dimensions, measure groups, and partitions.
Process Increment: Adds newly available fact data and process only to the relevant partitions. This processing option is supported for measure groups, and partitions.
Process Structure: If the cube is unprocessed, Analysis Services will process, if it is necessary, all the cube's dimensions. After that, Analysis Services will create only cube definitions. If this option is applied to a mining structure, it populates the mining structure with source data. The difference between this option and the Process Full option is that this option does not iterate the processing down to the mining models themselves. This processing option is supported for cubes and mining structures.
Unprocess : Drops the data in the object specified and any lower-level constituent objects. After the data is dropped, it is not reloaded. This processing option is supported for cubes, databases, dimensions, measure groups, mining models, mining structures, and partitions.
Process Default: Detects the process state of an object, and performs processing necessary to deliver unprocessed or partially processed objects to a fully processed state. This processing option is supported for cubes, databases, dimensions, measure groups, mining models, mining structures, and partitions.
61. What is a cube?
The basic unit of storage and analysis in Analysis Services is the cube. A cube is a collection of data that's been aggregated to allow queries to return data quickly.
For example, a cube of order data might be aggregated by time period and by title, making the cube fast when you ask questions concerning orders by week or orders by title.
The full form of AMO is Analysis Managament Objects. This is used to create or alter cubes from .NET code.
63. After creating the cube, if we added a new column to the OLTP table then how you add this new attribute to the cube?
Just open the data source view and on right click we find the option REFRESH. Click the REFRESH then it will add new attributes to the table which can be added to Cube.
1. What is the size of the Cube in your last Project?
Answer to this question varies from project to project and mainly depends on how BIG is your database and how COMPLEX the database design is. Generally for the database with a TRANSACTION TABLE of 50 crore records, the cube size will be around 100GB. So, better go with 100GB as answer to this question.
2. What is size of the database in your last Project?
You can expect this question immediately after you answer 100GB to the last question. The database size will be 600 to 800GB for which the cube will come to 100 GB. So go with 800GB for this question.
3. What is size of the fact(Transaction) table in your last Project?
This will be the next question if you answer 800GB as your dataabase size. Here he is not expecting SIZE in GBs but the interviewer will be expecting NUMBER OF ROWS in the Transaction table. Go with 57Crore records for this question.
4. How frequently you process the cube?
You have to be very careful here. Frequency of processing cube depends on HOW FREQUENTLY YOU ARE GETTING NEW DATA. Once the new data comes then SSIS team loads it and send a mail to SSAS team after load is completed successfully. Once SSAS team receives the mail then these guys will look for best time to PROCESS.
Typically we get data either Weekly or Monthly. So you can say that the processing of the cube will be done either Weekly or monthly.
5. How frequently you get DATA from clients?
This answer should be based on your last answer. IF you answered WEEKLY to last question then the Answer to this question also should be WEEKLY. IF MONTHLY for last question then this answer also should be MONTHLY.
6. What type of Processing Options you used to process the cube in your Project?
This is the toughest question to answer. This depends on DATA you have and CLIENTS requirements. Let me explain here.
If the database is SMALL, let's say it has only 1 crore records then people do FULL PROCESS as it wont take much time.
If the database is MEDIUM, let's say it has only 15 crore records then people prefer to do INCREMENTAL PROCESS unless CLIENTS ask us to do FULL PROCESS as it takes little bit of time.
If the database is HUGE, let's say it has more than 35 to 40 crore records then people prefer to do INCREMENTAL PROCESS unless CLIENTS ask us to do FULL PROCESS as it takes lot of time. In this case we TRY to convince clients for INCREMENTAL and if they don't agree then we don't have any other option.
Incremental process will come into picture ONLY when there is no updates to the OLD data i.e no changes to already existing data else NO OTHER OPTION than FULL PROCESS.
7. How you provide security to cube?
8. How you move the cube from one server to another?
Backup and restore – This is the simplest way. Take the Backup from development server and copy the backup to FTP folder of clients. After doing this drop a mail to Client's Admin and he will take care of RESTORE part.
Directly PROCESS the cube in PRODUCTION environment. For this you need access to Production which will not be given by clients unless the clients are *********. One of the client I worked for given FULL access to me ..
Under Srart –> All Programs –> Sql Server –> Analysis Services you can see deployment wizard. This is one way of moving the cube. This method has some steps to follow. First deploy your cube and FOUR files will be created in BIN folder of PROJECT folder. Copy those FOUR files and paste in Production server in any directory. Then OPEN this DEPLOYMENT Wizard in production and when it ask for Database file then point to the location where you copied the files. After that NEXT,NEXT,NEXT … OK .. Cube will be deployed and processed.
This way is most beautiful one. Synchronization, In this we will first deploy and process the cube in STAGING ENVIRONMENT and then we will go to production server. Connect to Analysis services in SSMS and select Synchronize by right clicking on Databases folder in SSMS of analysis services. Then select source as STAGING SERVER and then click on OK. The changes in the cube present in the Staging server will be copied to the production server.
9. What is the toughest challenge you face in your Project?
There are couple of this where we face difficulty.
While working on RELATIONSHIPS between Measure Groups and Dimensions.
10.What is the Schema of your last cube?
11. Why not STAR Schema ?
My data base design doesn't support STAR Schema.
12. What are the different relationships that you are used in your cube?
13. How you define Aggregations in your Project?
We defined the aggregations for MOST FREQUENTLY USED data in SSRS reports.
14. Size of SSAS team in your last Project?
15. How many Resources worked on same Cube in your Project?
Only 2 and one in morning shift and another in Evening shift.
16. How much time it take to Process the Cube?
This is Very very important question. This again depends on the SIZE of database,Complexity of the database and your server settings. For database with 50 cr transaction records, it generally takes 3.5 hrs.


The founder of many religons were real poeple does that make their claims true to. You are a christian becuase you come from the christian tradition and more importantly you are unable to cope with the real world.
This article has so many vague references, mistakes and misunderstandings that it is not suprising that by May 2005 it has only reveived 1 (now 2) comments.
Unfortunately with only 350 words at my disposal as against a whole article of errors and baseless doctrine I can hardly comment at length.
Paul, the depth of your faith is not in question. Your logic and knowledge and understanding of first century history is so bad that I suggest you stick to Rev. Dr Sellick's tactic of social commentary.
In response to a gentle and structured response I read two generalised and indistinct raves. If 350 words is too little, give me ONE detailed response to Paul Barnett's arguments.


Traditionally anti-gun MSNBC is probably feeling pretty shocked at the result of a couple of polls posted on their website.
This poll seems to have been running since early May.
This poll has been running since July 2nd.
To be fair, the Second Amendment protects individual's right to keep and bear arms from the government. There is no constitutionally guaranteed protection from private businesses, and in fact private property rights often trump other rights in our country's history. However, that doesn't mean people can't be upset about it.
Those are some pretty telling results. It should be interesting to see if MSNCB uses the results of either poll in subsequent reports. Both polls are still open.


CAMBRIDGE, Mass.--(BUSINESS WIRE)--Akebia Therapeutics, Inc. (Nasdaq:AKBA) today announced positive top-line results from two phase 3 active-controlled pivotal studies evaluating vadadustat, an investigational oral hypoxia-inducible factor prolyl hydroxylase inhibitor (HIF-PHI), in Japanese subjects with anemia due to chronic kidney disease (CKD). These studies were conducted by Akebia's development and commercialization collaboration partner in Japan, Mitsubishi Tanabe Pharma Corporation (MTPC). Each study, one in non-dialysis dependent subjects and one in hemodialysis-dependent subjects, met its primary endpoint. In addition, results from two phase 3 single-arm studies conducted by MTPC in peritoneal dialysis subjects and hemodialysis subjects further support vadadustat's potential in these indications. MTPC expects to submit a Japanese New Drug Application in 2019.
The phase 3 randomized, open-label, active-controlled correction and conversion study assessed the efficacy and safety of vadadustat compared to darbepoetin alfa, an erythropoiesis stimulating agent (ESA), in 304 Japanese non-dialysis dependent subjects with anemia due to CKD, with a treatment duration of 52 weeks. Data from the planned analysis at 24 weeks are provided. The study met its primary endpoint, with the mean hemoglobin (Hb) level at week 20 and week 24 at 11.66 g/dL (95% CI 11.49, 11.84 g/dL) for vadadustat-treated subjects compared to 11.93 g/dL (95% CI 11.76, 12.10 g/dL) for darbepoetin alfa-treated subjects. The difference in mean Hb was -0.26 g/dL (95% CI -0.50, -0.02 g/dL), achieving the pre-specified non-inferiority criterion of -0.75 g/dL. The incidence of adverse events (AEs) was 72.2% in the vadadustat-treated group compared to 73.2% in the darbepoetin alfa-treated group. The most common AEs reported in vadadustat-treated subjects were nasopharyngitis (14.6%), diarrhea (10.6%), constipation (5.3%), and contusion (5.3%). The incidence of serious adverse events (SAEs) was 13.9% in the vadadustat-treated group compared to 14.4% in the darbepoetin alfa-treated group; no SAE was considered related to study drug. No deaths were reported in the vadadustat-treated group, and one fatal myocardial infarction was reported in the darbepoetin alfa-treated group, which was assessed as not related to study drug.
The phase 3 randomized, double-blind, active-controlled conversion study assessed the efficacy and safety of vadadustat compared to darbepoetin alfa in 323 Japanese hemodialysis subjects with anemia due to CKD who had been receiving ESA therapy prior to study screening, with a treatment duration of 52 weeks. Group level data at 24 weeks from this ongoing double-blind study are provided. The study met its primary endpoint, with the mean Hb level at week 20 and week 24 at 10.61 g/dL (95% CI 10.45, 10.76 g/dL) for vadadustat-treated subjects compared to 10.65 g/dL (95% CI 10.50, 10.80 g/dL) for darbepoetin alfa-treated subjects. The difference in mean Hb was -0.05 g/dL (95% CI -0.26, 0.17 g/dL), achieving the pre-specified non-inferiority criterion of -0.75 g/dL. The incidence of AEs was 89.5% in the vadadustat-treated group compared to 88.2% in the darbepoetin alfa-treated group. The most common AEs reported in vadadustat-treated subjects were nasopharyngitis (19.8%), diarrhea (10.5%), and shunt stenosis (8.0%). The incidence of SAEs was 13.0% in the vadadustat-treated group compared to 10.6% in the darbepoetin alfa-treated group; no SAE was considered related to study drug.
The phase 3 open-label, single-arm J02 study assessed the efficacy and safety of vadadustat in 42 Japanese peritoneal dialysis subjects with anemia due to CKD, with a treatment duration of 24 weeks. The mean Hb level at week 20 and week 24 was 11.35 g/dL (95% CI 10.99, 11.70 g/dL) for vadadustat-treated subjects. Thirty-eight subjects (90.5%) experienced an AE and twelve (28.6%) experienced an SAE. One SAE of fatal myocardial ischemia was assessed as possibly related to vadadustat by the investigator.
The phase 3 open-label, single-arm J04 correction study evaluated the safety and efficacy of vadadustat, with a treatment duration of 24 weeks, in 24 Japanese hemodialysis subjects with anemia due to CKD who had not been receiving ESA therapy prior to study screening or who underwent ESA washout during screening. The mean Hb level at week 20 and week 24 was 10.75 g/dL (95% CI 10.35, 11.14 g/dL) for vadadustat-treated subjects. Twenty-three subjects (95.8%) experienced an AE, and seven (29.2%) experienced an SAE. No SAE was assessed as related to study drug, and no deaths were reported.
Akebia will discuss these findings on its previously announced fourth quarter and full-year 2018 investor update call on Monday, March 18, 2019 at 4:30 p.m. Eastern Time. Additional data from the studies are expected be presented by MTPC at an upcoming medical meeting.
In Japan, an estimated 13 million people are afflicted with advanced stages of CKD. Anemia is common in patients with CKD and its prevalence increases as CKD progresses. Injectable ESAs are currently the standard of care. Vadadustat, if approved for marketing, would provide patients with a once-daily oral treatment option and has the potential to set a new standard of care for the treatment of anemia due to CKD.
Vadadustat is an oral hypoxia-inducible factor (HIF) prolyl hydroxylase inhibitor currently in global phase 3 development for the treatment of anemia due to chronic kidney disease. Vadadustat's proposed mechanism of action is designed to mimic the physiologic effect of altitude on oxygen availability. At higher altitudes, the body responds to lower oxygen availability with increased production of HIF, which coordinates the interdependent processes of iron mobilization and erythropoietin production to increase red blood cell production and, ultimately, improve oxygen delivery. Vadadustat is an investigational therapy and is not approved by the U.S. Food and Drug Administration or any other regulatory authority.
This document contains forward-looking statements within the meaning of the federal securities laws. Such statements are based upon current plans, estimates and expectations that are subject to various risks and uncertainties. The inclusion of forward-looking statements should not be regarded as a representation that such plans, estimates and expectations will be achieved. Words such as "anticipate," "create," "expect," "project," "intend," "believe," "may," "will," "should," "plan," "could," "target," "contemplate," "estimate," "position," "predict," "potential," "opportunity," "working to," "look forward" and words and terms of similar substance used in connection with any discussion of future plans, actions or events identify forward-looking statements. All statements, other than historical facts, including regarding plans for regulatory submissions, the potential to set a new standard of care, and market and growth opportunity and potential, are forward-looking statements. Important factors that could cause actual results to differ materially from Akebia's plans, estimates or expectations could include, but are not limited to: whether the data from the phase 3 clinical trials of vadadustat in Japanese subjects will warrant a Japanese New Drug Application (JNDA) submission on the timeline expected, or at all, and whether any such JNDA will be approved; the timing and content of interactions with and decisions made by regulatory authorities; and success of others in developing competing products. Other risks and uncertainties include those identified under the heading "Risk Factors" in Akebia's most recently filed Quarterly Report on Form 10-Q, and other filings that Akebia may make with the U.S. Securities and Exchange Commission in the future. Akebia does not undertake, and specifically disclaims, any obligation to update any forward-looking statements contained in this press release.


text:
MP's grill Seretse over mysterious deaths of suspects in police custody
Minister of Defense Justice and Security Dikgakgamatso Seretse was last week backed against the wall as Members of Parliament accused the Botswana Police Service of heavy handedness and taking the law into their own hands. MP's last week expressed concern at BPS's heavy handedness and escalating instances of suspects who have died or disappeared while in the custody of security personnel.
"This is not right. Worse still, the police later carry out investigations into their own wrongs," said the MP's.
In response, Seretse absolved the police and his Ministry from any wrongdoing. He added that the police have no bearing whatsoever on the prosecuting authority.
"The Directorate of Public Prosecutions (DPP) has the prerogative to decide what action to take. We don't give them instructions, they decide whether to prosecute or not. If they found no substantial evidence to prosecute they are free not to take any action," said Seretse.
Seretse was responding to Lobatse MP Nehemiah Modubule, who had asked him to update Parliament on cases of unlawful killings or disappearance of suspects in police custody, including Moitaly Setlampoloka. Kweneng East MP, Moeng Pheto also wanted to know who is responsible for the opening of inquests and closure of cases implicating police personnel.
A robbery suspect, Setlampoloka was last seen with the police Mogoditshane, only for his body to be found in an un-inhabitated area near Mogoditshane in 2009. The police are suspected to have played a hand in his death and later covered up the murder. Six police officers were later charged with Setlampoloka's murder. Seretse confirmed that the trial dates in the Setlampoloka case have been set at 02-5/09/2014 and 15-16/09/2014. In the case of Mothusinyana Moagi who also died in police custody, parliament was told that the case has been completed at Francistown High Court and the accused police officer was acquitted and discharged of on 22/06/12. David Mongae's murder case was also completed at Lobatse High Court and four of the accused police officers were not found guilty.
Seretse also revealed that the DPP had closed the docket involving the death of Tshepho Molefe and Edison Mark Gumbo without any further action. The duo is also believed to have been shot by the Police.
Modubule said the string of acquittals and closure of cases implicating police officers was a result of poor police investigations and cover ups.
"I will not commit myself to such a serious indictment. Such is the periphery of the judges to decide," said Seretse in response.
Seretse also revealed that 10/07/2014 the Kasane Magistrate Court will hear an inquest hearing on a case in which two Namibian nationals, Richard Siyauya Munguni and Nyambe Nyambe were killed at the hands of Botswana Defense Force personnel. The inquest docket into the death of Alex Mwewa Matipa and Clark Kaholola was submitted to the District Commissioner's Office on 20/10/2011 and their Namibian compatriot and co-accused Ndongu Semalele was arrested on 18/03/2010. He was sentenced to 10 years imprisonment for entering Botswana through ungazetted point of entry and hunting a partially protected game animal. Modubule called for closer scrutiny of these suspicious deaths, saying Botswana stands at risk of losing the trust of its citizens and the international community.
Shocking revelations in suspected murder of suspect in police custody
Police Chiefs testified in favour of Ndelu Seretse
Police nab suspects in the killing of businessman

redpajama_set_name: RedPajamaCommonCrawl


Organisers of DJ Marshmello's show may face a criminal charge.
"Musical shows are meant for celebration, not when there is sadness across the country. This is not acceptable," said Rajiv Mittal of Akhil Bhartiya Hindu Kranti Dal after DJ Marshmello held his concert in Gurugram, on 16th February. The right-wing outfit (along with others) has also demanded the registration of a criminal case against the organiser of the event, as reported by IANS. Referring to the deadly Pulwama attacks that claimed the lives of more than 40 CRPF soldiers, the members of these outfits believe it to be wrong to hold a celebration of this calibre while the nation is plunged into mourning.
They've also submitted a memorandum (in this regard) to Sub-Divisional Magistrate (North) Sanjeev Singla on Monday, 18 February. Initially, members of the Bharat Tibet Sahyog Manch, Vishva Hindu Parishad (VHP), Bajrang Dal, Hindu Kranti Dal, Hindu Jagran Manch, Hindu Sena and Shiv Sena had threatened to disrupt the show if it was not cancelled. Due to stringent security measures, this was not achievable for the right-wingers. The American DJ, however, was aware of the situation and went ahead to observe a two-minute silence for the martyred jawans.
On 14th February, more than 40 CRPF personnel were killed after a car carrying explosives hit a CRPF convoy.


text:
West Hollywood Votes to Ban Fur Sales
By Michael Mountain, September 28, 2011
It's well-known for being the home of Sunset Strip, the Chateau Marmont and the House of Blues. It celebrates trendy fashion stores and liberal politics. It was home to Frank Sinatra, John Wayne and Howard Hughes. It was the first city to recognize same-gender domestic partnerships. And it has enacted various animal protection laws, including a ban on declawing cats.
Now West Hollywood has something of a cat fight on its hands, having taken the side of animal protection groups against fashion boutiques that sell fur.
A unanimous City Council vote last week to ban the sale of fur apparel has outraged the fashion industry, which is a key income producer for this very small city that's wedged between Los Angeles and Beverly Hills.
Business leaders say more than 90 stores that sell fur stores will be hurt.
"We attract luxury brands from around the world, and their customers," said Darren Gold, owner of a men's clothing store, and chairman of The Avenues, the city's designated fashion, design and art district. "This is basically saying that we no longer want those types of businesses to be in our city."
But Councilman John D'Amico, sponsor of the ban, is proud that West Hollywood will be the first U.S. city to ban fur sales, and hopes other cities will follow suit.
"This is one small way to have a conversation about how we live in the world," he said.
* For more, see USA Today or the Los Angeles Times.
What do you say? If you lived in West Hollywood, would you be willing to risk economic problems to the city and to yourself arising from a ban on fur? Let us know in a comment or on Facebook.
Categories: A-animals, Animals, Old News
Tagged: animal rights
Pit Bull Patrick Still in the Middle of a Turf War
Moving the Peanut for Farm Animals


LCHF Quarterly Digital Magazine 'LOSE IT!' third issue has been released.
I find it inspiring to hear others success stories, read more information about LCHF, as well as to see the creative recipes others use!
And since it's digital anyone globally can buy it. YAH!!!
To purchase, click on the link & follow the instructions….it's as easy as 1,2,3.
Happy reading and finding more support & inspiration to the LCHF way of life!
This entry was posted in lchf, LCHF recipes, Personal journey and tagged LCHF magazine, lchf recipes, LOSE IT! magazine by angelb38. Bookmark the permalink.


text:
Kirstie Alley Net Worth: Early Life, Career and Death
Last Updated on: January 26, 2023 by Prashant Mandal
Kirstie Alley Net Worth: Kirstie Alley had a $40 million net worth when she died. nominated for "Veronica's Closet" and "The Last Don" and won for "David's Mother." Alley has appeared in "Shoot to Kill," "Look Who's Talking," "Village of the Damned," "It Takes Two," and "Drop Dead Gorgeous."
Kirstie Alley travelled to L.A. to become an interior designer but ended up on game shows. These appearances led to lesser parts in TV and "Star Trek II: Wrath of Khan." After acting in the hit miniseries "North and South," she gained further high-profile employment. Rebecca Howe on "Cheers" became her signature role in 1987. She won one Emmy and one Golden Globe for her performance.
Kirstie Alley Net worth: She won an Emmy for her work in "David's Room" after "Cheers." She starred in "Veronica's Closet" in the late 1990s, then everything went wrong. Early in the 2000s, she made a few TV appearances here and there, most notably in the one-season comedy "Fat Actress." She stopped acting. During this time, the media covered her weight and sadness weekly. In 2010, she started competing on reality shows, and in 2011, she finished second on "Dancing with the Stars." She also established Organic Liaison.
Early Life of Kirstie Alley
Kirstie Alley: Career
Personal Life of Kirstie Alley
Death of Kirstie Alley
Read These Articles Too
Kirstie Alley Net Worth: Kirstie Alley was born in Wichita, Kansas, to Lillian and Robert, a lumberman. Craig and Colette are her siblings. Her high school was Wichita Southeast. She dropped out of Kansas State University after her second year. She relocated to Los Angeles to practise Scientology and design interiors. Alley won all rounds of "Match Game" and "Password Plus" in LA. In 1981, a drunk driver murdered her mother and wounded her father.
Kirstie Alley Net Worth: Alley was on "The Love Boat" in 1983 and then "Masquerade" on ABC. She appeared in "Sins of the Past" and "A Bunny's Tale," two episodes of "The Hitchhiker," and "North and South" with Patrick Swayze and James Read.
Alley also produced the NBC comedy "Veronica's Closet" in 1997. Alley was nominated for the Golden Globe and SAG Awards for her role as a New York City lingerie industry boss. In 1997, she appeared in "Toothless" and "The Last Don." She worked on "Dharma & Greg," "The King of Queens," "Family Sins," "While I Was Gone," and the TV movies "Salem Witch Trials," "Profoundly Normal," and "Write & Wrong" in the 2000s. In 2005, Alley portrayed a fictionalised version of herself on "Fat Actress" In 2010, she appeared in "Kirstie Alley's Big Life," about her weight loss struggles.
Alley competed on "Dancing with the Stars" with Maksim Chmerkovskiy in 2011. She finished behind NFL star Hines Ward. "The Manzanis," "Baby Sellers," and "You Can't Take My Daughter" are among her subsequent TV credits. Alley starred in the 2014 TV Land sitcom "Kirstie" and in 2016's "Scream Queens" season 2.
Kirstie Alley Net Worth: Alley married high-school lover Bob Alley in 1970; they separated in 1977. She married Parker Stevenson in 1983. After a miscarriage, they adopted William and Lillie. The couple divorced in 1997. Kirstie settled their divorce for $6 million. In today's money, that's $11 million.
Alley dropped 75 pounds while working for Jenny Craig from 2004 to 2007. In 2014, she was the company's spokeswoman.
Colon cancer claimed Kirstie Alley's life in December 2022, when she was 71 years old, her agent said this week. The actor's family put out a statement saying that the disease had just been discovered. In the United States, 151,030 people are anticipated to get a colorectal cancer diagnosis.
Type or Die Codes: Latest Codes (January2023)
List of Characters from Danganronpa V1,V2,V3
David Muir Face Cancer: What Happened To David Muir?
What Happend To Fernando del solar? Cause of his death
All Star Tower Defense Codes: Latest Codes (January2023)
Categories Net worth
Raid shadow legends codes 2023 January New Update
Southwest Florida Codes: Latest Codes (January 2023)


text:
LEGO Micro Cities
Build Your Own Mini Metropolis!
by Jeff Friesen
October 2018, 200 pp.
Print Book and FREE Ebook, $24.95
Ebook (PDF, Mobi, and ePub), $19.95
Download the Parts Lists
"This book is a LEGO dreamer's dream on a very small scale."
"Building on such a scale is a challenge on its own, but making whole cityscapes? It's LEGO art at its finest."
—Brick Pals
"Just flicking through its pages will have you looking at LEGO elements in completely different ways."
—BricksFanz
Build a beautiful LEGO® city that's small enough to hold in your hands! Filled with striking photos, step-by-step instructions, and countless ideas for customization, LEGO Micro Cities shows you how building small can open up new possibilities for the creative builder. You'll learn everything you need to know to create your own micro city, from building the foundation to adding convincing architectural details that will bring your city to life.
Jeff Friesen is an award-winning photographer and LEGO enthusiast whose work has been exhibited in the United States, Canada, Europe, and Japan. In 2017, he was awarded the Brothers Brick LEGO Creation of the Year. He posts his popular LEGO photography on Instagram (@jeff_works). Friesen lives in Victoria, British Columbia, Canada.
Upper Brick Side
Bridge Town
Hyperloop City
View the detailed Table of Contents
"Expert LEGO designer and builder Jeff Friesen presents an amazing book for LEGO fanatics, architecture fanatics, and anyone who enjoys building things."
"If you want to take your LEGO builds to the next level and really get a feel for how to design on the Micro scale, then this book has a lot of examples, ideas, and instructions to get you on your way."
—Game Vortex
Streamliner model: refer to downloadable parts list for the number of pieces required for each part.
Page 15: in the last row, 3023 should be 3020
Page 25: in the first row, 3062 should be 3062b
Page 35: at the bottom of the page, 3062 should be 3062b
Page 45: at the bottom of the page, the second 1x should be 2x
at the end of the second row, 16x should be 20x
Page 76: in 9, second row, the first 1x should be 2x
Page 83: in the second row, third position, 6x should be 12x
in the fourth row, the first 3x should be 1x; the second 3x should be 1x; the third 3x should be 2x; the fourth 3x should be 1x
Page 87: in 12, 16x should be 12x
Page 136:
in the first row, the fourth 2x should be 16x; the fifth 2x should be 4x; the last 2x should be 50x
in the second row, the first 2x should be 34x; the second 2x should be 4x; the third 2x should be 6x; the fourth 2x should be 4x; the fifth 2x should be 1x
in the third row, the first 2x should be 3x; the second 2x should be 1x; the fourth 2x should be 1x; the fifth 2x should be 6x; the sixth 2x should be 1x
Page 176: 3062 should be 3062b


MDC is providing designs for all types of dry cargo ships, based on latest knowlegde and development in hullform, propulsion, fuelling and cargohandling.
MDC cargo ship designs are all being customized to owner and operator/charterers requirements.
MDC is providing designs for all types of dry cargo (LoLo) ships.


The so-called "street fighter" segment – naked sport bikes – brings with it a certain macho sort of appeal. There's a certain raw hooliganism about them, offering the brutal power of super sport track-oriented steeds and eschewing all-out speed for agility; think less of a polished athlete at the starting line and more of a bruising thug running amok in your neighbourhood, breaking windows and running from the police.
But there is a gentleman to be found among the ruffians. The Suzuki GSX-S750 ABS is so new this year it even has a new name, following in the nomenclature of its super sport brother, the GSX-R750. Everything, from the frame to the fairings to the engine is new. Well, that inline four cylinder engine isn't exactly new; the block is from the 2005 GSX-R750 – rather than the one from the current model – chosen simply because the cylinders are more vertical to help package in a shorter wheelbase; don't worry, everything else is redesigned, and power is improved to 113 horsepower @ 10,5000 rpm this year, with torque also rising to 59.7 lb.ft. @ 9,000 rpm.
But simple power – while appreciated – isn't the best thing about this DOHC, 749-cc inline four, it's how it's delivered. With some sport bikes (as well as other larger V-twins), the torque can be peaky and sudden, which means very careful management of the throttle while leaving a turn – or even accelerating from a stoplight. But this 750 isn't that at all; both horsepower and torque are smooth and linear, leaving a rider to know exactly how the bike will react at every turn. Less experienced riders will appreciate the gentle touch; more experienced riders will like the precision as they bring their knee up from an apex. Apart from some slight vibration as the rpms soar past 5,000 on to a 12,000 rpm redline, this is one of the silkiest and most predictable engines I've ever experienced.
And don't take that "smooth delivery" as "slow to react", because it's simply not. If you want to tear a strip off the pavement, all it takes is a very sharp twist of the throttle and you'd better hang on. That torque coming on smoothly from rest just seems to build the faster you go. While it obviously doesn't have the rip-roaring acceleration of its bigger brother, the GSX-S1000, the 750 is no slouch, though I daresay it may not be the fastest of its competition, such as the Yamaha FZ-09, which has more torque at a lower rpm.
The GSX is also surprisingly quiet at low rpm, especially for a bike with sporting intentions, and when toodling around town, the wind and street noises drown out the exhaust. That, of course, changes with a simple twist of the wrist, but it never sounds mean. The new exhaust system, though, helps develop more lower- and mid-range power while also helping achieve strict Euro 4 emissions.
I thought it was just the engine's power – and my adept skills – that had this bike making consistently smooth takeoffs from a stop, until I realized it's more than that. Suzuki employs a "low rpm assist" that automatically rises the idle speed when it senses the bike is launching from a start. Oh, guffaw all you want, experienced bikers, but when you're caught in Toronto's notorious stop-and-go traffic, you'll appreciate it.
While the engine is the standout here, it isn't the only thing changed. With a wheelbase shorter than that of the GSX-R750, at 1,455 millimetres, riders sit a bit taller in the saddle than on the sport bike. But that short wheelbase means the bike is joyously tossable in the corners, and with a slightly aggressive forward riding position, the GSX just begs for a slalom. Even at a slightly porky 213 kilograms, it doesn't feel at all heavy.
Up front, it gets a new fully digital gauge screen, blacked-out levers and bars (in fact, this whole version is blacked-out, with another blue/black version available), revised front headlight and cowl; new LED tail lamps are out back and a standard bellypan (which was optional on the last model). The Bridgestone Battlax Hypersport 21 tires (120/70ZR17 in front, 180/55ZR17 out back) were even co-developed by Suzuki specifically for this S750, and grip inspires confidence to lean the bike over hard. And when you do have to brake, the Nissin four-pot opposed front callipers offer predictable stopping distance and good feel through the levers. The suspension, while fully capable for many types of terrain and riding, is only adjustable for preload.
At $9,339, the GSX-S750 is on the lower price point of the street fighter segment, and only if you feel the need for instant, brutal torque should you think of looking further afield. This is an easily rideable bike that is suitable for a wide variety of skill levels.


text:
Font: A- A A+
Greet you
Dr. Roger's Infirmary
Among the monuments, which Rudy can boast , one should not fail to mention the Infirmary of St. Charles, founded in 1858. by Dr. Julius Roger, Counselor of the Royal Sanitary and medical advisor of Duke Victor I. This small hotel, built in 1858. in the style of historicism with English neo-gothic elements, was founded by the Dukes Amelia and Victor. It was named in memory of the deceased Duke's father.
Dr. Roger was an exceptional figure. Apart from being a dedicated doctor and a social activist involved in helping the poorest, he initiated a public healthcare system. His first establishment, founded with this in mind, was St. Charles' Infirmary. All palace staff were treated free of charge, and the others for a small fee. The costs of maintaining the hospital were on the Dukes. Between 1861 and 1972 the nursery service was performed by the nuns of St Francis'Order.
Nowadays the historical building houses the Centre for Education at the Silesia Province Landscape Parks Complex.
Roger's Grave - The Cemetery Church of St. Mary Magdalene
Roger's Monument
Cistercian Period
The Prince Period
Contemporary period
Basilica Minor
The Monastery-Palace Complex
The English-style park
The Shrine of Our Lady
The Presbytery
Church of St. Mary Magdalene
The figure of St. John of Nepomuk
The figure of St. John of Nepomuk (stone)
Marian Column
The Railway Building
Other monuments
The Commune of Kuźnia Raciborska
The Rudy Abbacy
Sanctuary of the Humble Mother of God
The Marshal's Office of the Silesian Voivodeship
The Landscape Parks Complex
The Rudy Raciborskie Forestry Inspectorate
South - Western Cistercian Route
The Cystercian Route in Poland
The Association of Cystercian Communes
Project co-funded by the European Regional Development Fund within Innovative Economy Programme
All rights reserved - Info Kiosk Rudy © 2011
General Contractor: PRB ERBUD
Design and performance:
Thank you for your cooperation: CREDITS


Argentina mixes culture with impressive golf scene. It's about exploring the tango parlors and nightlife of Buenos Aires, the so-called "Paris of South America." It can also be about teeing off against the spectacular backdrop of the Andes, glacier-fed lakes and verdant forests of Patagonia. If you go, partake of it all, as you will do on this week long golf adventure.


text:
Series Formula 1
Friday, 23rd April 2021
Developing Our 2021 Power Unit
We kicked off 2021 with pole position and an oh-so-close second place in the Bahrain Grand Prix, before arriving in Imola and seeing Max take a solid win on Sunday at Round 2. But beyond the results there has been plenty to be encouraged about when it comes to performance.
At the opening round, Red Bull Racing were the team to beat on Saturday and Max saw victory slip away due to track limits, but Sergio's drive through the field, Pierre's excellent qualifying performance and Yuki's strong debut all pointed to a competitive power unit.
And it's a power unit that is all-new for this year, one that came together after an immense effort from Honda's teams in Sakura and Milton Keynes. As our head of power unit development Yasuaki Asaki explains, that came after a number of significant challenges over the past 12 months.
Asaki-san, Head of Power Unit Development
"The original plan was to implement this new structure PU this year in 2021," Asaki-san explains. "But then for a variety of reasons, it was decided not to proceed with a brand new PU. However, the thinking on this really changed when Honda announced that we would be leaving the sport. I went to President Hachigo, and said to him that we would really like to implement this new structure PU for our last year in the sport. And he kindly accepted that request.
"With the green light given, our engineers got to work on trying to get everything ready for the new season. That was never going to be an easy task, given the scope of the changes being made to the power unit's architecture.
"First of all we've changed the camshaft layout to be much more compact, and also brought its position lower down so it's closer to the ground," Asaki-san reveals. "We've also had to change the valve angle. The main point of what we've changed was to improve combustion efficiency. In order to do so we had to change the valve angle and in order to do that we had to change the camshaft."
"We've also had to make the head cover lower and more compact, which means that the way that air flows over it has become a lot better. And we've also lowered the centre of gravity of the ICE.
"Another thing we changed is the bore pitch, by reducing the distance between one bore and the next, we've made the engine itself shorter, smaller.
"In the old engine straddling the transmission we also had a bank offset whereby the left bank was slightly offset from the right bank. So what we've done is reverse this offset on the new engine so that the right bank is forward and the left bank is back. I'm sure you'll appreciate this is a completely new engine. And we've been able to bring it to a point where in just six months we've taken it testing without any issues.
"Another point that we've had to think about is the fact that combustion efficiency has go better. And the camshaft output has got better. Due to the rules of physics the amount of energy that can be stored has changed and it meant that the amount of exhaust energy has decreased. So compared to the recovery that we were getting last year, what we're having to do is increase the amount of crankshaft output, and at the same time ensure that there's a good level of exhaust output, exhaust temperature as well.
"So we've had a number of different development objectives and we believe we have met them."
Even though all of that work took place across a very condensed six-month period and required a focus on reliability as well, Asaki-san says his team were able to ensure all of the significant developments were included in the new design.
"I believe that we were able to implement everything that we have to in order to compete with Mercedes. We had a lot of cooperation from Red Bull, making sure that we could get the most from this new compact engine. Until the summer we were woking on the basis that it was going to be the previous bigger engine."
To pull off such an achievement required collaboration from different departments within the wider Honda company, as well as the power unit team leaning on its past experiences of major development challenges.
"This is the first time that we've gone as far as changing the structure of the PU itself. But I think the biggest challenge that we've had up to this point was back in the McLaren days, when we made big changes to the MGU-H, we changed the positioning of the compressor and turbine in relation to the V bank - I think the biggest challenges were back then.
"You may be aware that a part of what helped us solve those problems back then was the cooperation with Honda Jet. As I mentioned Honda Motor has helped us with various different points, but one of the points I'd like to mention is a cylinder sleeve plating, produced by our plant in Kumamoto - it's called the Kumamoto plating. The Kumamoto plant is actually a motorbike factory, but within Honda there's a substantial amount of collaboration between the two-wheel production and four-wheel production areas."
In some ways, it seems like a huge undertaking given the fact that this year is Honda's last as an official power unit supplier in F1. But Asaki-san says the efforts of the engineers was worth it both from the desire to show our capabilities, and also to simply be as competitive as possible across what is a record-breaking 23-race season.
"I had acknowledged in some ways that it was an incredibly challenging target. But I think our engineers have had both the understanding that yes we've only got a year left but also we've got a full year left and we have to do something with that time, and they've worked hard during the time that we have had."
All of the work off-track went unseen over the past six months, but the competitiveness at the start of this season is the first sign of what has been achieved from a performance point of view. Now the challenge is to try and turn that into the best possible results on track.
Published on 23 April 2021 @ 08:11 GMT+0
Partners online
Change language English日本語
Website by redwing.media


text:
The Worst Ten Manchester Attractions. Tourists and Visitors: Avoid!
We at New Manchester Walks have been at the forefront of getting more people to visit and stay in Manchester. Customers have come from the Midlands, London, Holland – the record is New Zealand; beat that! – to go on our tours. But we want you to enjoy your visit, whether it be an afternoon away from regular golf in Northenden or a once in a lifetime city break. So when you've been on our tours and want something else to do here are the top ten things it's best not to avoid or be wary of, from No. 10, the least worst of the ten, to No. 1, the pits.
The Gay Village
Once it was revolutionary, now it's passé. The pubs play deafening crap music, the restaurants are over-priced, the place is overrun with chavs, and no one has made any attempt to get to grips with its history.
The Trafford Centre
Shops you can get everywhere else in the middle of nowhere, soon to be linked by a tram line that won't work. Shop local!
Curry Mile
Don't bother. Head to the This and That in the Northern Quarter or the Lahori Kebabish on Cheetham Hill Road.
Walking round John Rylands Library by yourself
As we've explained in a previous blog, it may be one of the world's greatest libraries, but it's run with the ingenuity of the Labour Party's Brexit strategy. There are next to no explanatory plaques and quite frankly if there were any we wouldn't trust them to enlighten you. Come on, Marketing Manchester. Come on, Rylands management. This is the setting for the oldest piece of the New Testament in existence, so where are the hordes of American tourists queuing up for a look-see? When I put it to Visit Manchester/Marketing Manchester that we should be promoting this remarkable entity to potential visitors from the American Bible Belt, I was told that they might be the wrong kind of tourists! You couldn't make it up if you tried. Manchester: the only city that tries not to attract visitors. Meanwhile, book on our tour. It's the only way.
Tours of the Midland Hotel in which they tell you this was where Rolls met Royce.
If the guide tells you Rolls met Royce at the Midland Hotel they haven't done their research and they're just regurgitating what everybody else has said that was wrong in the first place. Sorry Midland, but Rolls and Royce never went anywhere near your hotel. You've got a great history, hotel, promote it properly!
Coronation Street tour
"Walk down the famous cobbles". But that's all you do. You can't go inside and see where it's filmed, like you could at the much better value Granada Studios Tour of old. We have been beseeching the bosses at Corrie for years to get them to link up their tour with our locations coach tour, to no avail.
Sightseeing Bus Tour
A recorded commentary cobbled together from Wikipedia devoid of anything interesting. No guide, no pay-ee the money.
Man United Museum and Stadium Tour
You get to see Fred's shirt hanging up. It cost them £52 million. It'll cost you £25.=
The Christmas Markets
Any day of the year you can walk through the city centre and buy a so-called sausage made of reconstituted bits of meat the dog wouldn't eat. The difference before Christmas is that you can buy one with a bit of garlic added. That, apparently, makes it German. Or you can buy a huge cheese that would feed a Swiss canton. 90 per cent of which you'll throw away. And if you think the markets are actually German, then you probably think chicken tikka masala is authentically Indian.
Ever since the Science Museum in London took over our science and industry version some years ago what should be one of the country's most spectacular museums, given that Manchester invented modern industry and gave the world some of its most important scientific discoveries (the atom, the computer, graphene), has gone to the dogs. They recently sold out much of their heritage as the location of the world's first passenger railway by allowing National Rail to build the pointless Ordsall Chord, which has knackered trips on the oldest line that were so popular with school parties and railway buffs. Or to put it another way, the museum contains Liverpool Road Station, the world's first and oldest. I have been pushing Visit Manchester and Marketing Manchester to get the museum to put a humungously big sign up outside, telling the population of the planet that here is "the world's first and oldest railway station". A really big sign. Imagine such a feature was somewhere in America. You'd never hear the last of it. But this is Manchester, where tourism is still in the prehistoric era.
« CELEBRATING 100 YEARS OF WOMEN IN PARLIAMENT
How To Improve the Tourism Experience in Manchester (6 new ideas and what I've done about them). »